DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on PER_PEOPLE_F

Line 501: FROM PER_PEOPLE_F P, HZ_PARTIES HZ , PER_ASSIGNMENTS_X A, PER_PERSON_TYPES T

497: l_party_id NUMBER;
498:
499: CURSOR c_employee IS
500: SELECT hz.party_id
501: FROM PER_PEOPLE_F P, HZ_PARTIES HZ , PER_ASSIGNMENTS_X A, PER_PERSON_TYPES T
502: WHERE A.PERSON_ID = P.PERSON_ID
503: AND HZ.PARTY_ID = P.PARTY_ID
504: AND HZ.PARTY_TYPE = 'PERSON'
505: AND A.PRIMARY_FLAG = 'Y'