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_ALL_ASSIGNMENTS_F

Line 80: per_all_assignments_f paa,

76: FROM hxc_tk_group_queries htgq,
77: hxc_tk_groups htg,
78: hxc_tk_group_query_criteria htgqc,
79: per_all_people_f ppf,
80: per_all_assignments_f paa,
81: per_person_type_usages_f ptu,
82: per_person_types ppt
83: WHERE ppf.person_id = paa.person_id
84: AND ppt.person_type_id = ptu.person_type_id

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 127: per_all_assignments_f paa,

123: FROM hxc_tk_group_queries htgq,
124: hxc_tk_groups htg,
125: hxc_tk_group_query_criteria htgqc,
126: per_all_people_f ppf,
127: per_all_assignments_f paa,
128: per_person_type_usages_f ptu,
129: per_person_types ppt
130: WHERE ppf.person_id = paa.person_id
131: AND ppt.person_type_id = ptu.person_type_id

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 6264: from per_all_assignments_f paa

6260: WHERE ppf.person_id = p_resource_id
6261: AND p_from_period < ppf.effective_end_date
6262: AND p_to_period > ppf.effective_start_date
6263: AND EXISTS ( select 'x'
6264: from per_all_assignments_f paa
6265: WHERE ppf.person_id = paa.person_id
6266: AND paa.primary_flag = 'Y'
6267: AND paa.assignment_type IN ('E', 'C')
6268: AND p_from_period < paa.effective_end_date