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.HXC_TIMEKEEPER_PROCESS dependencies on PER_PEOPLE_F

Line 110: FROM per_people_f ppf2, per_all_assignments_f paa2

106: AND ppf.person_id = NVL (p_resource_id, ppf.person_id)
107: AND htgq.include_exclude = 'I'
108: AND htgqc.criteria_type = 'PERSON'
109: AND ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
110: FROM per_people_f ppf2, per_all_assignments_f paa2
111: WHERE ppf2.person_id = paa2.person_id
112: AND paa2.primary_flag = 'Y'
113: AND paa2.assignment_type IN ('E', 'C')
114: AND p_start_period <= paa2.effective_end_date

Line 156: FROM per_people_f ppf2, per_all_assignments_f paa2

152: AND htg.business_group_id = ppf.business_group_id
153: AND htgq.include_exclude = 'I'
154: AND htgqc.criteria_type = 'PERSON'
155: AND ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
156: FROM per_people_f ppf2, per_all_assignments_f paa2
157: WHERE ppf2.person_id = paa2.person_id
158: AND paa2.primary_flag = 'Y'
159: AND paa2.assignment_type IN ('E', 'C')
160: AND p_start_period <= paa2.effective_end_date

Line 4907: FROM per_people_f ppf

4903: ) IS
4904: SELECT DISTINCT NVL (ppf.employee_number, ppf.npw_number) employee_number,
4905: ppf.full_name,
4906: ppf.effective_end_date
4907: FROM per_people_f ppf
4908: WHERE ppf.person_id = p_resource_id
4909: AND p_from_period < ppf.effective_end_date
4910: AND p_to_period > ppf.effective_start_date
4911: AND EXISTS ( select 'x'