APPS.PYUDET dependencies on PER_PERSON_TYPES

Line 176: INDEX(ppt, PER_PERSON_TYPES_PK) */

172: -- csr_mode12 = Cursor for select emp for mode 1 and 2 --
173: ------------------------------------------------------------
174: cursor csr_mode12 is
175: select /*+ ORDERED
176: INDEX(ppt, PER_PERSON_TYPES_PK) */
177: max(peo.person_id) p_id,
178: peo.full_name,
179: peo.national_identifier,
180: nvl(peo.per_information10,'N') agg_flag,

Line 192: per_person_types ppt

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
196: asg.payroll_id = g_payroll_id)

Line 1843: per_person_types ppt

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')
1847: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)