DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_CERTIFICATION_OBJ

Line 597: SELECT HZ_CERTIFICATION_OBJ(

593: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
594: FROM HZ_CREDIT_RATINGS
595: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CREDIT_RATING_OBJ_TBL),
596: CAST(MULTISET (
597: SELECT HZ_CERTIFICATION_OBJ(
598: P_ACTION_TYPE,
599: NULL, -- COMMON_OBJ_ID
600: CERTIFICATION_ID,
601: CERTIFICATION_NAME,

Line 617: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CERTIFICATION_OBJ_TBL),

613: CREATION_DATE,
614: LAST_UPDATE_DATE,
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