APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_EXT_ATTRIBUTE_OBJ_TBL
Line 176: HZ_EXT_ATTRIBUTE_OBJ_TBL())
172: WHERE
173: OSR.OWNER_TABLE_ID = PRO.PARTY_ID
174: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
175: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), 176: HZ_EXT_ATTRIBUTE_OBJ_TBL()) 177: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
178: WHERE PRO.PARTY_ID = P.PARTY_ID AND P.PARTY_ID = P_PERSON_ID
179: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
180: