DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_PARTY_USAGE_OBJ

Line 643: HZ_PARTY_USAGE_OBJ_TBL())

639: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
640: FROM HZ_FINANCIAL_PROFILE
641: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
642: HZ_CONTACT_PREF_OBJ_TBL(),
643: HZ_PARTY_USAGE_OBJ_TBL())
644: FROM HZ_ORGANIZATION_PROFILES PRO, HZ_PARTIES P
645: WHERE PRO.PARTY_ID = P.PARTY_ID
646: AND PRO.PARTY_ID = P_ORGANIZATION_ID
647: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);