APPS.ENG_VAL_TO_ID dependencies on HZ_PARTIES

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'

Line 558: FROM hz_parties

554:
555: IF l_id IS NULL THEN -- take this as a group name
556:
557: SELECT party_id INTO l_id
558: FROM hz_parties
559: WHERE party_name = p_assignee AND party_type = 'GROUP';
560: END IF;
561:
562: RETURN l_id;