DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_CODE_ASSIGNMENT_OBJ

Line 465: SELECT HZ_CODE_ASSIGNMENT_OBJ(

461: HZ_EDI_CP_BO_TBL(),
462: HZ_EFT_CP_BO_TBL(),
463: HZ_RELATIONSHIP_OBJ_TBL(),
464: CAST(MULTISET (
465: SELECT HZ_CODE_ASSIGNMENT_OBJ(
466: P_ACTION_TYPE,
467: NULL, -- COMMON_OBJ_ID
468: CODE_ASSIGNMENT_ID,
469: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),

Line 487: AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),

483: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
484: RANK)
485: FROM HZ_CODE_ASSIGNMENTS
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,