APPS.IGS_HE_EXTRACT2_PKG dependencies on HZ_PARTIES

Line 9562: FROM HZ_PARTIES P,

9558: P.KNOWN_AS PREFERRED_GIVEN_NAME,
9559: PP.GENDER SEX,
9560: PP.DATE_OF_BIRTH BIRTH_DT,
9561: PP.PERSON_NAME FULL_NAME
9562: FROM HZ_PARTIES P,
9563: HZ_PERSON_PROFILES PP
9564: WHERE P.PARTY_ID = PP.PARTY_ID
9565: AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
9566: AND NVL (PP.EFFECTIVE_END_DATE, SYSDATE)

Line 9840: FROM hz_parties

9836:
9837: -- smaddali added cursor for bug#3361317
9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number
9840: FROM hz_parties
9841: WHERE party_id = cp_person_id ;
9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;
9843:
9844: BEGIN

Line 10475: FROM hz_parties pe

10471: AND return_name = cp_return_name ;
10472:
10473: CURSOR c_pers_number IS
10474: SELECT pe.party_number person_number
10475: FROM hz_parties pe
10476: WHERE pe.party_id = p_person_id;
10477:
10478: l_message VARCHAR2(2000);
10479:

Line 10623: FROM hz_parties

10619:
10620: -- smaddali added cursor for bug#3361317
10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
10622: SELECT party_number person_number
10623: FROM hz_parties
10624: WHERE party_id = cp_person_id ;
10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;
10626:
10627: TYPE INTRM_RECORDS IS TABLE OF NUMBER(15) NOT NULL INDEX BY BINARY_INTEGER;