DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_PERSON_TYPES_TL

Line 407: ,per_person_types_tl ptt

403: ,per_jobs_tl pjt
404: ,per_all_positions pps
405: ,per_person_type_usages_f ptu
406: ,per_person_types pts
407: ,per_person_types_tl ptt
408: ,hr_all_organization_units_tl orgTl
409: ,per_business_groups pbg
410: WHERE ppf.person_id = paf.person_id
411: AND (pts.system_person_type IN ('EMP','CWK') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 495: ,per_person_types_tl ptt

491: ,per_jobs_tl pjt
492: ,per_all_positions pps
493: ,per_person_type_usages_f ptu
494: ,per_person_types pts
495: ,per_person_types_tl ptt
496: ,hr_all_organization_units_tl orgTl
497: ,per_business_groups pbg
498: WHERE ppf.person_id = paf.person_id
499: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))