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_TYPES

Line 194: -- thru the per_person_type_usages table as opposed to per_person_types table.

190:
191: BEGIN
192:
193: -- Bug: 5971387 - The following query has been modified to drive the person_type_id
194: -- thru the per_person_type_usages table as opposed to per_person_types table.
195:
196: SELECT count(*)
197: INTO l_cnt
198: FROM per_person_types ppt,

Line 198: FROM per_person_types ppt,

194: -- thru the per_person_type_usages table as opposed to per_person_types table.
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

Line 379: per_person_types ppt,

375: /* select min(ppf.effective_start_date), max(ppf.effective_end_date)
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

Line 399: per_person_types ppt,

395: max(per.effective_end_date)
396: INTO
397: l_p_start_date, l_p_end_date
398: FROM
399: per_person_types ppt,
400: per_people_f per
401: WHERE
402: per.person_id = p_resource_id
403: AND ppt.person_type_id = per.person_type_id

Line 429: -- table as opposed to per_person_types table as is the case in the above query

425: */
426:
427: -- The above query changed as follows for bug 4687842. Basically the query has
428: -- been changed to drive the person_type_id thru the per_person_type_usages
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,

Line 434: per_person_types ppt,

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
438: AND ptu.person_type_id = ppt.person_type_id