DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_CREDIT_RATING_OBJ

Line 490: SELECT HZ_CREDIT_RATING_OBJ(

486: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
487: AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
488: HZ_FINANCIAL_BO_TBL(),
489: CAST(MULTISET (
490: SELECT HZ_CREDIT_RATING_OBJ(
491: P_ACTION_TYPE,
492: NULL, -- COMMON_OBJ_ID
493: CREDIT_RATING_ID,
494: DESCRIPTION,

Line 595: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CREDIT_RATING_OBJ_TBL),

591: CREATION_DATE,
592: LAST_UPDATE_DATE,
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