APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_PERSON_PROFILES
Line 177: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
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:
181: l_debug_prefix VARCHAR2(30) := '';