APPS.IGS_HE_EXTRACT2_PKG dependencies on HZ_PERSON_PROFILES

Line 9563: HZ_PERSON_PROFILES PP

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)
9567: AND P.PARTY_ID = P_PERSON_ID;

Line 9577: FROM HZ_PERSON_PROFILES HPP,

9573: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
9574: SELECT HPP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID,
9575: SD.RELIGION_CD RELIGION,
9576: HPP.MARITAL_STATUS MARITAL_STATUS
9577: FROM HZ_PERSON_PROFILES HPP,
9578: IGS_PE_STAT_DETAILS SD
9579: WHERE HPP.PARTY_ID = SD.PERSON_ID(+)
9580: AND HPP.PARTY_ID = P_PERSON_ID
9581: AND SYSDATE BETWEEN HPP.EFFECTIVE_START_DATE