APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ_TBL

Line 175: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

171: FROM HZ_ORIG_SYS_REFERENCES OSR
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);

Line 361: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))

357: FROM HZ_ORIG_SYS_REFERENCES OSR
358: WHERE
359: OSR.OWNER_TABLE_ID = OCR.ORG_CONTACT_ROLE_ID
360: AND OWNER_TABLE_NAME = 'HZ_ORG_CONTACT_ROLES'
361: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
362: FROM HZ_ORG_CONTACT_ROLES OCR
363: WHERE ORG_CONTACT_ID = P_ORG_CONT_ID;
364:
365: l_debug_prefix VARCHAR2(30) := '';

Line 575: HZ_ORIG_SYS_REF_OBJ_TBL(),

571: R.COMMENTS,
572: R.START_DATE,
573: R.END_DATE,
574: R.STATUS,
575: HZ_ORIG_SYS_REF_OBJ_TBL(),
576: NULL, --PERSON_PROFILE_OBJ,
577: HZ_ORG_CONTACT_ROLE_OBJ_TBL(),
578: HZ_PARTY_SITE_BO_TBL(),
579: HZ_PHONE_CP_BO_TBL(),