DBA Data[Home] [Help]

APPS.PYUDET dependencies on PER_PERSON_TYPE_USAGES_F

Line 191: per_person_type_usages_f ptu,

187: peo.effective_end_date
188: from per_all_people_f peo,
189: per_all_assignments_f asg,
190: per_periods_of_service pps,
191: per_person_type_usages_f ptu,
192: per_person_types ppt
193: where peo.person_id = asg.person_id
194: and peo.business_group_id = g_business_group_id
195: and (g_payroll_id is null or

Line 1842: from per_person_type_usages_f ptu,

1838: and p_m34_rec.effective_date between peo.effective_start_date and peo.effective_end_date
1839: and (pps.actual_termination_date is null or
1840: p_m34_rec.effective_date between pps.date_start and pps.actual_termination_date)
1841: and exists (select 1
1842: from per_person_type_usages_f ptu,
1843: per_person_types ppt
1844: where ptu.person_id = peo.person_id
1845: and ptu.person_type_id = ppt.person_type_id
1846: and ppt.system_person_type in ('EMP','EMP_APL')