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 278: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

274: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID
275: AND LANGUAGE = USERENV('LANG')) LOCATION_DESC
276: , PERSON_REFERRED_BY_ID
277: , SUPERVISOR_ID
278: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
279: and p_eff_date between papf.effective_start_date and
280: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
281: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
282: and p_eff_date between papf.effective_start_date and

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

277: , SUPERVISOR_ID
278: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
279: and p_eff_date between papf.effective_start_date and
280: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
281: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
282: and p_eff_date between papf.effective_start_date and
283: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_CWK_NUMBER
284: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
285: and p_eff_date between papf.effective_start_date and

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

280: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_EMP_NUMBER
281: , (SELECT NPW_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
282: and p_eff_date between papf.effective_start_date and
283: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_CWK_NUMBER
284: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID
285: and p_eff_date between papf.effective_start_date and
286: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) SUPERVISOR_NAME
287: , SPECIAL_CEILING_STEP_ID
288: , RECRUITMENT_ACTIVITY_ID

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

925: , to_char(REPORT_DATE,'YYYY-MM-DD')
926: , REPORT_TIME
927: , REPORT_METHOD
928: , PERSON_REPORTED_BY
929: , (SELECT FULL_NAME FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PERSON_REPORTED_BY
930: and p_eff_date between papf.effective_start_date and
931: nvl(papf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PERSON_REPORTED_BY_NAME
932: , PERSON_REPORTED_TO
933: , WITNESS_DETAILS

Line 1258: AND PARENT_TABLE = 'PER_ALL_PEOPLE_F'

1254: PARTY_ID,
1255: VALIDITY
1256: FROM PER_PHONES
1257: WHERE PARENT_ID = p_person_id
1258: AND PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1259: and p_eff_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/YYYY'));
1260:
1261: --cursor to fetch the qualification details
1262: CURSOR csr_qualification_record(p_person_id number,p_business_group_id number,p_eff_date date)

Line 2446: and pp.parent_table = 'PER_ALL_PEOPLE_F'

2442: ,per_phones pp
2443: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2444: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2445: and ppf.person_id = pp.parent_id(+)
2446: and pp.parent_table = 'PER_ALL_PEOPLE_F'
2447: and pp.phone_id = p_srch_criteria(i).p_phone_id;
2448:
2449: 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;
2450: close srch_filtrd;