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

148: l_cnt NUMBER;
149: BEGIN
150:
151: -- Bug: 5971387 - The following query has been modified to drive the person_type_id
152: -- thru the per_person_type_usages table as opposed to per_person_types table.
153:
154: SELECT count(*)
155: INTO l_cnt
156: FROM per_person_types ppt,

Line 156: FROM per_person_types ppt,

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

Line 249: per_person_types ppt,

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

Line 269: per_person_types ppt,

265: max(per.effective_end_date)
266: INTO
267: l_p_start_date, l_p_end_date
268: FROM
269: per_person_types ppt,
270: per_people_f per
271: WHERE
272: per.person_id = p_resource_id
273: AND ppt.person_type_id = per.person_type_id

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

295: */
296:
297: -- The above query changed as follows for bug 4687842. Basically the query has
298: -- been changed to drive the person_type_id thru the per_person_type_usages
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,

Line 304: per_person_types ppt,

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