Oracle APPS HRMS Table Structur

Personnel Information of employees


SELECT PA.PERSON_ID,PRO.TITLE||' '||PRO.FIRST_NAME||' '||LAST_NAME, PJ.NAME AS JOB ,OU.NAME AS ORGANIZATION,
PA.ADDRESS_LINE1,ADDRESS_TYPE,PA.POSTAL_CODE,PA.TELEPHONE_NUMBER_1,PA.TOWN_OR_CITY
FROM PER_ADDRESSES PA, per_all_people_f PRO,HR_ALL_ORGANIZATION_UNITS OU,PER_ALL_ASSIGNMENTS_F PAS,PER_JOBS PJ,hr_locations LC
WHERE PA.PERSON_ID = PRO.PERSON_ID
AND PAS.ORGANIZATION_ID = OU.ORGANIZATION_ID
AND PAS.LOCATION_ID = LC.LOCATION_ID
AND PRO.PERSON_ID = PAS.PERSON_ID
AND PRO.BUSINESS_GROUP_ID = 202
AND PJ.JOB_ID = PAS.JOB_ID
AND PRO.PERSON_ID = '55'
AND PRO.effective_end_date > sysdate
AND PAS.effective_end_date > sysdate;