DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 3396: per_person_type_usages_f pptu,

3392: cursor c_terminated_employee_asg(p_person_id in number) is
3393: SELECT paf.effective_end_date
3394: FROM per_people_f ppf,
3395: per_person_types ppt,
3396: per_person_type_usages_f pptu,
3397: per_assignments_f paf
3398: WHERE ppf.person_id = 57504
3399: -- and ppf.person_type_id = ppt.person_type_id
3400: AND ppt.system_person_type = 'EX_EMP'