Oracle Apps Query - List the Employees assigned to a given organization

Select ppf.EMPLOYEE_NUMBER, ppt.USER_PERSON_TYPE, ppf.FIRST_NAME, ppf.LAST_NAME, ppf.sex, ppf.START_DATE, ppf.ORIGINAL_DATE_OF_HIRE , ppf.EMAIL_ADDRESS, GSB.NAME SET_OF_BOOK_NAME, GCC.CONCATENATED_SEGMENTS EXPENSE_REPORT_COSTING, pa.STYLE ADDRESS_STYLE, pa.ADDRESS_LINE1, pa.ADDRESS_TYPE, pa.COUNTRY, pa.POSTAL_CODE , pa.REGION_1, pa.REGION_2, pa.TOWN_OR_CITY, ppo.NAME ORGANIZATION_NAME, HL.LOCATION_CODE, HL.DESCRIPTION LOCATION_DESCRIPTION, PJ.NAME JOB_NAME, PPG.GROUP_NAME PEOPLE_GROUP_NAME , PPA.EMPLOYMENT_CATEGORY,PPA.assignment_category, ppf2.full_name DIRECT_MANAGER
from PER_ALL_PEOPLE_f ppf
, PER_ALL_ASSIGNMENTS_f ppa
, PER_ALL_ORGANIZATION_UNITS ppo
, PER_PERSON_TYPES ppt
, GL_SETS_OF_BOOKS GSB
, PER_ADDRESSES PA
, PER_JOBS PJ
, PAY_PEOPLE_GROUPS PPG
, HR_LOCATIONS HL
, PER_ALL_PEOPLE_f ppf2
, GL_CODE_COMBINATIONS_KFV GCC
where ppa.person_id = ppf.person_id
and ppf2.person_id(+) = ppa.supervisor_id
and sysdate between ppf2.EFFECTIVE_START_DATE(+) and nvl(ppf2.EFFECTIVE_END_DATE(+),sysdate)
AND GCC.CODE_COMBINATION_ID(+) = PPA.DEFAULT_CODE_COMB_ID
and ppt.PERSON_TYPE_ID = ppf.PERSON_TYPE_ID
and sysdate between ppf.EFFECTIVE_START_DATE and nvl(ppf.EFFECTIVE_END_DATE,sysdate)
and sysdate between ppa.EFFECTIVE_START_DATE and nvl(ppa.EFFECTIVE_END_DATE,sysdate)
and ppo.organization_id(+) = ppa.organization_id
and gsb.set_of_books_id(+) = ppa.set_of_books_id
and pa.person_id = ppf.person_id
AND PPG.PEOPLE_GROUP_ID = PPA.PEOPLE_GROUP_ID
AND PPA.LOCATION_ID = HL.LOCATION_ID(+)
AND PPA.JOB_ID = PJ.JOB_ID(+)
AND ppo.name in (:org_name);