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 645: from per_person_type_usages_f ptu, per_person_types ppt

641:
642:
643: cursor fpt_ptu_details is
644: select ptu.person_type_id, effective_start_date, effective_end_date
645: from per_person_type_usages_f ptu, per_person_types ppt
646: where person_id = p_person_id
647: and effective_start_date >= p_effective_date
648: and ptu.person_type_id = ppt.person_type_id
649: and system_person_type in ('APL','EX_APL','EX_EMP');

Line 658: from per_person_type_usages_f ptu, per_person_types ppt

654: and effective_start_date = cp_effective_start_date;
655:
656: cursor chk_ptu_exists(cp_effective_start_date date) is
657: select 'Y'
658: from per_person_type_usages_f ptu, per_person_types ppt
659: where person_id = p_person_id
660: and effective_start_date = cp_effective_start_date
661: and ptu.person_type_id = ppt.person_type_id
662: and ppt.system_person_type in ('APL','EX_APL');

Line 1052: from per_person_types ppt

1048: for update of person_type_id;
1049:
1050: cursor csr_get_person_type(cp_person_type_id number) IS
1051: select ppt.system_person_type
1052: from per_person_types ppt
1053: where ppt.person_type_id = cp_person_type_id;
1054:
1055: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1056: select ptu.person_type_id, ppt.system_person_type

Line 1059: ,per_person_types ppt

1055: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1056: select ptu.person_type_id, ppt.system_person_type
1057: ,ptu.effective_start_date, ptu.effective_end_date
1058: from per_person_type_usages_f ptu
1059: ,per_person_types ppt
1060: where ptu.person_id = cp_person_id
1061: and (cp_effective_date between ptu.effective_start_date
1062: and ptu.effective_end_date
1063: or

Line 1076: l_system_person_type per_person_types.system_person_type%TYPE;

1072:
1073: l_business_group_id per_all_people_f.business_group_id%TYPE;
1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;

Line 1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1082: l_first_person_type_id per_person_types.person_type_id%TYPE;
1083: l_current_person_type per_person_types.person_type_id%TYPE;

Line 1080: l_new_person_type_id per_person_types.person_type_id%TYPE;

1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1082: l_first_person_type_id per_person_types.person_type_id%TYPE;
1083: l_current_person_type per_person_types.person_type_id%TYPE;
1084: l_start_date date;

Line 1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;

1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1082: l_first_person_type_id per_person_types.person_type_id%TYPE;
1083: l_current_person_type per_person_types.person_type_id%TYPE;
1084: l_start_date date;
1085:

Line 1082: l_first_person_type_id per_person_types.person_type_id%TYPE;

1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1082: l_first_person_type_id per_person_types.person_type_id%TYPE;
1083: l_current_person_type per_person_types.person_type_id%TYPE;
1084: l_start_date date;
1085:
1086: l_new_effective_date DATE;

Line 1083: l_current_person_type per_person_types.person_type_id%TYPE;

1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1082: l_first_person_type_id per_person_types.person_type_id%TYPE;
1083: l_current_person_type per_person_types.person_type_id%TYPE;
1084: l_start_date date;
1085:
1086: l_new_effective_date DATE;
1087: --

Line 1525: from per_person_types ppt

1521: order by peo.effective_start_date ASC;
1522: --
1523: cursor csr_get_person_type(cp_person_type_id number) IS
1524: select ppt.system_person_type
1525: from per_person_types ppt
1526: where ppt.person_type_id = cp_person_type_id;
1527:
1528: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1529: select ptu.person_type_id, ppt.system_person_type

Line 1532: ,per_person_types ppt

1528: cursor csr_ptu_details(cp_person_id number, cp_effective_date date) is
1529: select ptu.person_type_id, ppt.system_person_type
1530: ,ptu.effective_start_date, ptu.effective_end_date
1531: from per_person_type_usages_f ptu
1532: ,per_person_types ppt
1533: where ptu.person_id = cp_person_id
1534: and cp_effective_date between ptu.effective_start_date
1535: and ptu.effective_end_date
1536: and ppt.person_type_id = ptu.person_type_id

Line 1546: l_system_person_type per_person_types.system_person_type%TYPE;

1542:
1543: l_business_group_id per_all_people_f.business_group_id%TYPE;
1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;
1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

Line 1549: l_new_person_type_id per_person_types.person_type_id%TYPE;

1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;
1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1551: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1552:
1553: l_new_effective_date DATE;

Line 1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;
1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1551: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1552:
1553: l_new_effective_date DATE;
1554: --

Line 1551: l_new_sys_person_type per_person_types.system_person_type%TYPE;

1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;
1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1551: l_new_sys_person_type per_person_types.system_person_type%TYPE;
1552:
1553: l_new_effective_date DATE;
1554: --
1555: l_per_effective_start_date date;

Line 1878: from per_person_types ppt, per_person_type_usages_f ptu

1874:
1875: -- start changes for bug 8337406
1876: cursor csr_chk_EMP_or_CWK(cp_person_id number, cp_effective_date date) is
1877: select 1
1878: from per_person_types ppt, per_person_type_usages_f ptu
1879: where ptu.person_type_id = ppt.person_type_id
1880: and ppt.business_group_id = p_business_group_id
1881: AND ptu.person_id = p_person_id
1882: and ppt.system_person_type in ('EMP','CWK')

Line 2301: l_system_person_type per_person_types.system_person_type%type;

2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;
2301: l_system_person_type per_person_types.system_person_type%type;
2302: l_effective_date date;
2303: l_effective_start_date date;
2304: l_effective_end_date date;
2305: l_default_start_time per_business_groups.default_start_time%type;

Line 2343: from per_person_types ppt

2339: ,ppf.date_of_birth
2340: ,ppf.party_id
2341: ,ppf.effective_start_date
2342: ,ppt.system_person_type
2343: from per_person_types ppt
2344: ,per_people_f ppf
2345: where ppf.person_id = p_person_id
2346: and ppt.person_type_id = ppf.person_type_id
2347: and ppt.business_group_id + 0 = ppf.business_group_id

Line 2392: ,per_person_types ppt

2388: --
2389: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
2390: SELECT null
2391: FROM per_person_type_usages_f ptu
2392: ,per_person_types ppt
2393: WHERE person_id = cp_person_id
2394: AND (effective_start_date > cp_termination_date
2395: OR
2396: cp_termination_date between effective_start_date