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

Line 157: per_person_type_usages_f ptu,

153:
154: SELECT count(*)
155: INTO l_cnt
156: FROM per_person_types ppt,
157: per_person_type_usages_f ptu,
158: per_people_f per
159: WHERE per.person_id = p_resource_id
160: AND ptu.person_id = per.person_id
161: AND ptu.person_type_id = ppt.person_type_id

Line 250: per_person_type_usages_f ptu

246: into l_p_start_date, l_p_end_date
247: from per_people_f ppf,
248: per_assignments_f paf,
249: per_person_types ppt,
250: per_person_type_usages_f ptu
251: where ppf.person_id = p_resource_id
252: and paf.person_id = ppf.person_id
253: and ptu.person_id = ppf.person_id
254: and ptu.person_type_id=ppt.person_type_id

Line 303: FROM per_person_type_usages_f ptu,

299: -- table as opposed to per_person_types table as is the case in the above query
300: -- which causes bug 4687842.
301: SELECT MIN (per.effective_start_date), MAX (per.effective_end_date)
302: INTO l_p_start_date, l_p_end_date
303: FROM per_person_type_usages_f ptu,
304: per_person_types ppt,
305: per_people_f per
306: WHERE per.person_id = p_resource_id
307: AND ptu.person_id = per.person_id