DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_FINANCIAL_PROF_OBJ

Line 619: SELECT HZ_FINANCIAL_PROF_OBJ(

615: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
616: FROM HZ_CERTIFICATIONS
617: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CERTIFICATION_OBJ_TBL),
618: CAST(MULTISET (
619: SELECT HZ_FINANCIAL_PROF_OBJ(
620: P_ACTION_TYPE,
621: NULL, -- COMMON_OBJ_ID
622: FINANCIAL_PROFILE_ID,
623: ACCESS_AUTHORITY_DATE,

Line 641: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),

637: CREATION_DATE,
638: LAST_UPDATE_DATE,
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