DBA Data[Home] [Help]

APPS.PYUDET dependencies on PER_PERIODS_OF_SERVICE

Line 190: per_periods_of_service pps,

186: peo.effective_start_date,
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

Line 1824: per_periods_of_service pps

1820: pps.last_standard_process_date,
1821: p_m34_rec.effective_date
1822: from per_all_people_f peo,
1823: per_all_assignments_f asg,
1824: per_periods_of_service pps
1825: where asg.business_group_id = g_business_group_id
1826: and peo.business_group_id = g_business_group_id
1827: and peo.person_id = asg.person_id
1828: -- Bug 6864422 modified p_m34_rec.full_name to substr of peo.last_name length