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_TYPE_USAGES_F

Line 580: from per_person_type_usages_f ptu

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
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

Line 625: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

621: l_person_rec csr_get_person_details%ROWTYPE;
622: l_future_person_rec csr_get_person_details%ROWTYPE;
623: l_ptu_rec csr_ptu_details%ROWTYPE;
624:
625: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
626: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
627: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
628: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
629:

Line 626: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;

622: l_future_person_rec csr_get_person_details%ROWTYPE;
623: l_ptu_rec csr_ptu_details%ROWTYPE;
624:
625: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
626: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
627: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
628: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
629:
630:

Line 627: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

623: l_ptu_rec csr_ptu_details%ROWTYPE;
624:
625: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
626: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
627: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
628: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
629:
630:
631: begin

Line 628: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

624:
625: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
626: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
627: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
628: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
629:
630:
631: begin
632: if g_debug then

Line 898: from per_person_type_usages_f ptu

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
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

Line 948: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

944: l_person_rec csr_get_person_details%ROWTYPE;
945: l_future_person_rec csr_get_person_details%ROWTYPE;
946: l_ptu_rec csr_ptu_details%ROWTYPE;
947:
948: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
949: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
950: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
951: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
952: -- BUG4081676

Line 949: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;

945: l_future_person_rec csr_get_person_details%ROWTYPE;
946: l_ptu_rec csr_ptu_details%ROWTYPE;
947:
948: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
949: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
950: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
951: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
952: -- BUG4081676
953: cursor csr_get_per_ovn is

Line 950: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

946: l_ptu_rec csr_ptu_details%ROWTYPE;
947:
948: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
949: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
950: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
951: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
952: -- BUG4081676
953: cursor csr_get_per_ovn is
954: select object_version_number

Line 951: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

947:
948: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
949: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
950: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
951: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
952: -- BUG4081676
953: cursor csr_get_per_ovn is
954: select object_version_number
955: from per_all_people_f

Line 1371: from per_person_type_usages_f ptu

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
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

Line 1415: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

1411: l_person_rec csr_get_person_details%ROWTYPE;
1412: l_future_person_rec csr_get_person_details%ROWTYPE;
1413: l_ptu_rec csr_ptu_details%ROWTYPE;
1414:
1415: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1416: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1417: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1418: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1419: --

Line 1416: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;

1412: l_future_person_rec csr_get_person_details%ROWTYPE;
1413: l_ptu_rec csr_ptu_details%ROWTYPE;
1414:
1415: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1416: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1417: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1418: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1419: --
1420: l_ex_per_rec csr_get_person_details%ROWTYPE;

Line 1417: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

1413: l_ptu_rec csr_ptu_details%ROWTYPE;
1414:
1415: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1416: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1417: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1418: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1419: --
1420: l_ex_per_rec csr_get_person_details%ROWTYPE;
1421: l_apl_per_rec csr_get_person_details%ROWTYPE;

Line 1418: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

1414:
1415: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1416: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1417: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1418: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1419: --
1420: l_ex_per_rec csr_get_person_details%ROWTYPE;
1421: l_apl_per_rec csr_get_person_details%ROWTYPE;
1422: --

Line 2174: FROM per_person_type_usages_f ptu

2170: for update nowait;
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