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.PYUDET dependencies on PER_PERSON_TYPE_USAGES_F

Line 258: per_person_type_usages_f ptu,

254: scl.segment1 -- Bug#8497477
255: from per_all_people_f peo,
256: per_all_assignments_f asg,
257: per_periods_of_service pps,
258: per_person_type_usages_f ptu,
259: per_person_types ppt,
260: pay_all_payrolls_f ppf, -- Bug#8497477
261: hr_soft_coding_keyflex scl -- Bug#8497477
262: where peo.person_id = asg.person_id

Line 2046: from per_person_type_usages_f ptu,

2042: and p_m34_rec.effective_date between peo.effective_start_date and peo.effective_end_date
2043: and (pps.actual_termination_date is null or
2044: p_m34_rec.effective_date between pps.date_start and pps.actual_termination_date)
2045: and exists (select 1
2046: from per_person_type_usages_f ptu,
2047: per_person_types ppt
2048: where ptu.person_id = peo.person_id
2049: and ptu.person_type_id = ppt.person_type_id
2050: and ppt.system_person_type in ('EMP','EMP_APL')

Line 2086: from per_person_type_usages_f ptu,

2082: and p_m34_rec.effective_date between peo.effective_start_date and peo.effective_end_date
2083: and (pps.actual_termination_date is null or
2084: p_m34_rec.effective_date between pps.date_start and pps.actual_termination_date)
2085: and exists (select 1
2086: from per_person_type_usages_f ptu,
2087: per_person_types ppt
2088: where ptu.person_id = peo.person_id
2089: and ptu.person_type_id = ppt.person_type_id
2090: and ppt.system_person_type in ('EMP','EMP_APL')

Line 2124: from per_person_type_usages_f ptu,

2120: and p_m34_rec.effective_date between peo.effective_start_date and peo.effective_end_date
2121: and (pps.actual_termination_date is null or
2122: p_m34_rec.effective_date between pps.date_start and pps.actual_termination_date)
2123: and exists (select 1
2124: from per_person_type_usages_f ptu,
2125: per_person_types ppt
2126: where ptu.person_id = peo.person_id
2127: and ptu.person_type_id = ppt.person_type_id
2128: and ppt.system_person_type in ('EMP','EMP_APL')

Line 2162: from per_person_type_usages_f ptu,

2158: and p_m34_rec.effective_date between peo.effective_start_date and peo.effective_end_date
2159: and (pps.actual_termination_date is null or
2160: p_m34_rec.effective_date between pps.date_start and pps.actual_termination_date)
2161: and exists (select 1
2162: from per_person_type_usages_f ptu,
2163: per_person_types ppt
2164: where ptu.person_id = peo.person_id
2165: and ptu.person_type_id = ppt.person_type_id
2166: and ppt.system_person_type in ('EMP','EMP_APL')