APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PE_STAT_DETAILS

Line 9578: IGS_PE_STAT_DETAILS SD

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
9582: AND NVL(HPP.EFFECTIVE_END_DATE, SYSDATE);