DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on PER_PERSON_TYPE_USAGES_F

Line 711: FROM per_person_types PPT ,per_person_type_usages_f pptu

707: AND PERA1.primary_flag = 'Y'
708: AND PERA1.ASSIGNMENT_TYPE IN ('E','C') --
709: AND EXISTS
710: (SELECT '1'
711: FROM per_person_types PPT ,per_person_type_usages_f pptu
712: WHERE PPT.system_person_type IN ('EMP','EMP_APL','CWK') --
713: AND PPT.person_type_id = pptu.person_type_id
714: AND pptu.Person_Id = PERF.person_id
715: ))