DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on PER_PERSON_TYPES

Line 602: FROM per_person_types PPT

598: AND PERA1.primary_flag = 'Y'
599: AND PERA1.ASSIGNMENT_TYPE IN ('E','C')-- bug 12388225
600: AND EXISTS
601: (SELECT '1'
602: FROM per_person_types PPT
603: WHERE PPT.system_person_type IN ('EMP','EMP_APL','CWK') --
604: AND PPT.person_type_id = PERF.person_type_id));
605:
606: l_progress VARCHAR2(10) := '000';

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: ))