DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_CODE_ASSIGNMENT_OBJ

Line 383: SELECT HZ_CODE_ASSIGNMENT_OBJ(

379: HZ_EMAIL_CP_BO_TBL(),
380: HZ_WEB_CP_BO_TBL(),
381: HZ_SMS_CP_BO_TBL(),
382: CAST(MULTISET (
383: SELECT HZ_CODE_ASSIGNMENT_OBJ(
384: P_ACTION_TYPE,
385: NULL, -- COMMON_OBJ_ID
386: CODE_ASSIGNMENT_ID,
387: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),

Line 405: AND OWNER_TABLE_ID = P_PERSON_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),

401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
402: RANK)
403: FROM HZ_CODE_ASSIGNMENTS
404: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
405: AND OWNER_TABLE_ID = P_PERSON_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
406: CAST(MULTISET (
407: SELECT HZ_PERSON_LANG_OBJ(
408: P_ACTION_TYPE,
409: NULL, -- COMMON_OBJ_ID