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 199: per_person_type_usages_f ptu,

195:
196: SELECT count(*)
197: INTO l_cnt
198: FROM per_person_types ppt,
199: per_person_type_usages_f ptu,
200: per_people_f per
201: WHERE per.person_id = p_resource_id
202: AND ptu.person_id = per.person_id
203: AND ptu.person_type_id = ppt.person_type_id

Line 380: per_person_type_usages_f ptu

376: into l_p_start_date, l_p_end_date
377: from per_people_f ppf,
378: per_assignments_f paf,
379: per_person_types ppt,
380: per_person_type_usages_f ptu
381: where ppf.person_id = p_resource_id
382: and paf.person_id = ppf.person_id
383: and ptu.person_id = ppf.person_id
384: and ptu.person_type_id=ppt.person_type_id

Line 433: FROM per_person_type_usages_f ptu,

429: -- table as opposed to per_person_types table as is the case in the above query
430: -- which causes bug 4687842.
431: SELECT MIN (per.effective_start_date), MAX (per.effective_end_date)
432: INTO l_p_start_date, l_p_end_date
433: FROM per_person_type_usages_f ptu,
434: per_person_types ppt,
435: per_people_f per
436: WHERE per.person_id = p_resource_id
437: AND ptu.person_id = per.person_id