eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_RECORD dependencies on PER_ALL_PEOPLE_F

Line 11: Type p_person_id is table of per_all_peoplE_f.person_id%type index by binary_integer;

7: p_person out nocopy person_record,
8: p_error out nocopy varchar2)
9: is
10:
11: Type p_person_id is table of per_all_peoplE_f.person_id%type index by binary_integer;
12: Type p_business_group_id is table of per_all_peoplE_f.business_group_id%type index by binary_integer;
13: Type p_srch_date is table of date index by binary_integer;
14:
15:

Line 12: Type p_business_group_id is table of per_all_peoplE_f.business_group_id%type index by binary_integer;

8: p_error out nocopy varchar2)
9: is
10:
11: Type p_person_id is table of per_all_peoplE_f.person_id%type index by binary_integer;
12: Type p_business_group_id is table of per_all_peoplE_f.business_group_id%type index by binary_integer;
13: Type p_srch_date is table of date index by binary_integer;
14:
15:
16:

Line 297: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

293: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID
294: AND LANGUAGE = USERENV('LANG')) LOCATION_DESC
295: , PERSON_REFERRED_BY_ID
296: , SUPERVISOR_ID
297: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
298: and p_eff_date between papf.effective_start_date and
299: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
300: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
301: and p_eff_date between papf.effective_start_date and

Line 300: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

296: , SUPERVISOR_ID
297: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
298: and p_eff_date between papf.effective_start_date and
299: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
300: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
301: and p_eff_date between papf.effective_start_date and
302: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_CWK_NUMBER
303: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
304: and p_eff_date between papf.effective_start_date and

Line 303: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

299: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
300: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
301: and p_eff_date between papf.effective_start_date and
302: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_CWK_NUMBER
303: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
304: and p_eff_date between papf.effective_start_date and
305: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_NAME
306: , SPECIAL_CEILING_STEP_ID
307: , RECRUITMENT_ACTIVITY_ID

Line 948: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PERSON_REPORTED_BY

944: , to_char(REPORT_DATE,'YYYY-MM-DD')
945: , REPORT_TIME
946: , REPORT_METHOD
947: , PERSON_REPORTED_BY
948: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PERSON_REPORTED_BY
949: and p_eff_date between papf.effective_start_date and
950: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PERSON_REPORTED_BY_NAME
951: , PERSON_REPORTED_TO
952: , WITNESS_DETAILS

Line 1279: AND PARENT_TABLE = 'PER_ALL_PEOPLE_F'

1275: PARTY_ID,
1276: VALIDITY
1277: FROM PER_PHONES
1278: WHERE PARENT_ID = p_person_id
1279: AND PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1280: and p_eff_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/YYYY'));
1281:
1282: --cursor to fetch the qualification details
1283: CURSOR csr_qualification_record(p_person_id number,p_business_group_id number,p_eff_date date)

Line 1605: and pp.parent_table = 'PER_ALL_PEOPLE_F'

1601: ,per_phones pp
1602: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1603: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1604: and ppf.person_id = pp.parent_id(+)
1605: and pp.parent_table = 'PER_ALL_PEOPLE_F'
1606: and pp.phone_id = p_srch_criteria(i).p_phone_id;
1607:
1608: fetch srch_filtrd bulk collect into p_srch_filter_tbl.person_id,p_srch_filter_tbl.business_group_id,p_srch_filter_tbl.p_srch_dt;
1609: close srch_filtrd;