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_APPLICANT_INTERNAL dependencies on PER_PERSON_TYPES

Line 111: l_new_sys_person_type per_person_types.system_person_type%TYPE;

107: -- CWK APL
108: -- OTHER APL
109: -- ------------------------------------------------------
110:
111: l_new_sys_person_type per_person_types.system_person_type%TYPE;
112:
113: begin
114:
115: if p_current_person_type in ('EMP','EMP_APL') then

Line 150: l_new_sys_person_type per_person_types.system_person_type%TYPE;

146: -- CWK EX_APL
147: -- OTHER EX_APL
148: -- ------------------------------------------------------
149:
150: l_new_sys_person_type per_person_types.system_person_type%TYPE;
151:
152: begin
153: --
154: if p_current_person_type = 'EX_EMP_APL' then

Line 574: from per_person_types ppt

570: for update of person_type_id;
571:
572: cursor csr_get_person_type(cp_person_type_id number) IS
573: select ppt.system_person_type
574: from per_person_types ppt
575: where ppt.person_type_id = cp_person_type_id;
576:
577: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
578: select ptu.person_type_id, ppt.system_person_type

Line 581: ,per_person_types ppt

577: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
578: select ptu.person_type_id, ppt.system_person_type
579: ,ptu.effective_start_date, ptu.effective_end_date
580: from per_person_type_usages_f ptu
581: ,per_person_types ppt
582: where ptu.person_id = cp_person_id
583: and cp_effective_date between ptu.effective_start_date
584: and ptu.effective_end_date
585: and ppt.person_type_id = ptu.person_type_id

Line 596: l_system_person_type per_person_types.system_person_type%TYPE;

592:
593: l_business_group_id per_all_people_f.business_group_id%TYPE;
594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;
600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

Line 599: l_new_person_type_id per_person_types.person_type_id%TYPE;

595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;
600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
601: l_new_sys_person_type per_person_types.system_person_type%TYPE;
602:
603: l_new_effective_date DATE;

Line 600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;
600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
601: l_new_sys_person_type per_person_types.system_person_type%TYPE;
602:
603: l_new_effective_date DATE;
604: --

Line 601: l_new_sys_person_type per_person_types.system_person_type%TYPE;

597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;
600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
601: l_new_sys_person_type per_person_types.system_person_type%TYPE;
602:
603: l_new_effective_date DATE;
604: --
605: l_per_effective_start_date date;

Line 892: from per_person_types ppt

888: for update of person_type_id;
889:
890: cursor csr_get_person_type(cp_person_type_id number) IS
891: select ppt.system_person_type
892: from per_person_types ppt
893: where ppt.person_type_id = cp_person_type_id;
894:
895: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
896: select ptu.person_type_id, ppt.system_person_type

Line 899: ,per_person_types ppt

895: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
896: select ptu.person_type_id, ppt.system_person_type
897: ,ptu.effective_start_date, ptu.effective_end_date
898: from per_person_type_usages_f ptu
899: ,per_person_types ppt
900: where ptu.person_id = cp_person_id
901: and (cp_effective_date between ptu.effective_start_date
902: and ptu.effective_end_date
903: or

Line 916: l_system_person_type per_person_types.system_person_type%TYPE;

912:
913: l_business_group_id per_all_people_f.business_group_id%TYPE;
914: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
915: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
916: l_system_person_type per_person_types.system_person_type%TYPE;
917: l_ovn per_all_people_f.object_version_number%TYPE;
918:
919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;

Line 919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

915: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
916: l_system_person_type per_person_types.system_person_type%TYPE;
917: l_ovn per_all_people_f.object_version_number%TYPE;
918:
919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;
921: l_new_sys_person_type per_person_types.system_person_type%TYPE;
922: l_first_person_type_id per_person_types.person_type_id%TYPE;
923: l_current_person_type per_person_types.person_type_id%TYPE;

Line 920: l_new_person_type_id per_person_types.person_type_id%TYPE;

916: l_system_person_type per_person_types.system_person_type%TYPE;
917: l_ovn per_all_people_f.object_version_number%TYPE;
918:
919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;
921: l_new_sys_person_type per_person_types.system_person_type%TYPE;
922: l_first_person_type_id per_person_types.person_type_id%TYPE;
923: l_current_person_type per_person_types.person_type_id%TYPE;
924: l_start_date date;

Line 921: l_new_sys_person_type per_person_types.system_person_type%TYPE;

917: l_ovn per_all_people_f.object_version_number%TYPE;
918:
919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;
921: l_new_sys_person_type per_person_types.system_person_type%TYPE;
922: l_first_person_type_id per_person_types.person_type_id%TYPE;
923: l_current_person_type per_person_types.person_type_id%TYPE;
924: l_start_date date;
925:

Line 922: l_first_person_type_id per_person_types.person_type_id%TYPE;

918:
919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;
921: l_new_sys_person_type per_person_types.system_person_type%TYPE;
922: l_first_person_type_id per_person_types.person_type_id%TYPE;
923: l_current_person_type per_person_types.person_type_id%TYPE;
924: l_start_date date;
925:
926: l_new_effective_date DATE;

Line 923: l_current_person_type per_person_types.person_type_id%TYPE;

919: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
920: l_new_person_type_id per_person_types.person_type_id%TYPE;
921: l_new_sys_person_type per_person_types.system_person_type%TYPE;
922: l_first_person_type_id per_person_types.person_type_id%TYPE;
923: l_current_person_type per_person_types.person_type_id%TYPE;
924: l_start_date date;
925:
926: l_new_effective_date DATE;
927: --

Line 1365: from per_person_types ppt

1361: order by peo.effective_start_date ASC;
1362: --
1363: cursor csr_get_person_type(cp_person_type_id number) IS
1364: select ppt.system_person_type
1365: from per_person_types ppt
1366: where ppt.person_type_id = cp_person_type_id;
1367:
1368: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1369: select ptu.person_type_id, ppt.system_person_type

Line 1372: ,per_person_types ppt

1368: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1369: select ptu.person_type_id, ppt.system_person_type
1370: ,ptu.effective_start_date, ptu.effective_end_date
1371: from per_person_type_usages_f ptu
1372: ,per_person_types ppt
1373: where ptu.person_id = cp_person_id
1374: and cp_effective_date between ptu.effective_start_date
1375: and ptu.effective_end_date
1376: and ppt.person_type_id = ptu.person_type_id

Line 1386: l_system_person_type per_person_types.system_person_type%TYPE;

1382:
1383: l_business_group_id per_all_people_f.business_group_id%TYPE;
1384: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1385: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1386: l_system_person_type per_person_types.system_person_type%TYPE;
1387: l_ovn per_all_people_f.object_version_number%TYPE;
1388:
1389: l_new_person_type_id per_person_types.person_type_id%TYPE;
1390: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

Line 1389: l_new_person_type_id per_person_types.person_type_id%TYPE;

1385: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1386: l_system_person_type per_person_types.system_person_type%TYPE;
1387: l_ovn per_all_people_f.object_version_number%TYPE;
1388:
1389: l_new_person_type_id per_person_types.person_type_id%TYPE;
1390: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1391: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1392:
1393: l_new_effective_date DATE;

Line 1390: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

1386: l_system_person_type per_person_types.system_person_type%TYPE;
1387: l_ovn per_all_people_f.object_version_number%TYPE;
1388:
1389: l_new_person_type_id per_person_types.person_type_id%TYPE;
1390: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1391: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1392:
1393: l_new_effective_date DATE;
1394: --

Line 1391: l_new_sys_person_type per_person_types.system_person_type%TYPE;

1387: l_ovn per_all_people_f.object_version_number%TYPE;
1388:
1389: l_new_person_type_id per_person_types.person_type_id%TYPE;
1390: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1391: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1392:
1393: l_new_effective_date DATE;
1394: --
1395: l_per_effective_start_date date;

Line 2084: l_system_person_type per_person_types.system_person_type%type;

2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;
2084: l_system_person_type per_person_types.system_person_type%type;
2085: l_effective_date date;
2086: l_effective_start_date date;
2087: l_effective_end_date date;
2088: l_default_start_time per_business_groups.default_start_time%type;

Line 2126: from per_person_types ppt

2122: ,ppf.date_of_birth
2123: ,ppf.party_id
2124: ,ppf.effective_start_date
2125: ,ppt.system_person_type
2126: from per_person_types ppt
2127: ,per_people_f ppf
2128: where ppf.person_id = p_person_id
2129: and ppt.person_type_id = ppf.person_type_id
2130: and ppt.business_group_id + 0 = ppf.business_group_id

Line 2175: ,per_person_types ppt

2171: --
2172: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
2173: SELECT null
2174: FROM per_person_type_usages_f ptu
2175: ,per_person_types ppt
2176: WHERE person_id = cp_person_id
2177: AND (effective_start_date > cp_termination_date
2178: OR
2179: cp_termination_date between effective_start_date