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: -- ER FPT

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: -- ER FPT
631: l_person_type_id1 number;

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: -- ER FPT
631: l_person_type_id1 number;
632: l_exists varchar2(1) := 'N';

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 1058: from per_person_type_usages_f ptu

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

Line 1108: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

1104: l_person_rec csr_get_person_details%ROWTYPE;
1105: l_future_person_rec csr_get_person_details%ROWTYPE;
1106: l_ptu_rec csr_ptu_details%ROWTYPE;
1107:
1108: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1109: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1110: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1112: -- BUG4081676

Line 1109: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;

1105: l_future_person_rec csr_get_person_details%ROWTYPE;
1106: l_ptu_rec csr_ptu_details%ROWTYPE;
1107:
1108: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1109: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1110: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1112: -- BUG4081676
1113: cursor csr_get_per_ovn is

Line 1110: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

1106: l_ptu_rec csr_ptu_details%ROWTYPE;
1107:
1108: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1109: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1110: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1112: -- BUG4081676
1113: cursor csr_get_per_ovn is
1114: select object_version_number

Line 1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

1107:
1108: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1109: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1110: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1112: -- BUG4081676
1113: cursor csr_get_per_ovn is
1114: select object_version_number
1115: from per_all_people_f

Line 1531: from per_person_type_usages_f ptu

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

Line 1575: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

1571: l_person_rec csr_get_person_details%ROWTYPE;
1572: l_future_person_rec csr_get_person_details%ROWTYPE;
1573: l_ptu_rec csr_ptu_details%ROWTYPE;
1574:
1575: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1576: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1577: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1578: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1579: --

Line 1576: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;

1572: l_future_person_rec csr_get_person_details%ROWTYPE;
1573: l_ptu_rec csr_ptu_details%ROWTYPE;
1574:
1575: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1576: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1577: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1578: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1579: --
1580: l_ex_per_rec csr_get_person_details%ROWTYPE;

Line 1577: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

1573: l_ptu_rec csr_ptu_details%ROWTYPE;
1574:
1575: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1576: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1577: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1578: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1579: --
1580: l_ex_per_rec csr_get_person_details%ROWTYPE;
1581: l_apl_per_rec csr_get_person_details%ROWTYPE;

Line 1578: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

1574:
1575: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1576: l_ptu_ovn per_person_type_usages_f.object_version_number%TYPE;
1577: l_ptu_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
1578: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1579: --
1580: l_ex_per_rec csr_get_person_details%ROWTYPE;
1581: l_apl_per_rec csr_get_person_details%ROWTYPE;
1582: --

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 2391: FROM per_person_type_usages_f ptu

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