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_DATAUPD dependencies on PER_PERSON_TYPE_USAGES_F

Line 25: -- + per_person_type_usages_f

21: -- applicant assignments opened and the application has a termination date.
22: --
23: -- The following tables are updated:
24: -- + per_all_people_f
25: -- + per_person_type_usages_f
26: -- + per_applications
27: --
28: -- Scenario:
29: --

Line 86: FROM per_person_type_usages_f ptu

82: for update nowait;
83: --
84: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
85: SELECT null
86: FROM per_person_type_usages_f ptu
87: ,per_person_types ppt
88: WHERE person_id = cp_person_id
89: AND (effective_start_date > cp_termination_date
90: OR