DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PARTY_USAGE_OBJ

Line 544: HZ_PARTY_USAGE_OBJ_TBL())

540: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
541: FROM HZ_FINANCIAL_PROFILE
542: WHERE PARTY_ID = P_PERSON_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
543: HZ_CONTACT_PREF_OBJ_TBL(),
544: HZ_PARTY_USAGE_OBJ_TBL())
545: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
546: WHERE PRO.PARTY_ID = P.PARTY_ID
547: AND PRO.PARTY_ID = P_PERSON_ID
548: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);