DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PERSON_LANG_OBJ

Line 407: SELECT HZ_PERSON_LANG_OBJ(

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
410: LANGUAGE_USE_REFERENCE_ID,
411: LANGUAGE_NAME,

Line 427: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_LANG_OBJ_TBL),

423: CREATION_DATE,
424: LAST_UPDATE_DATE,
425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
426: FROM HZ_PERSON_LANGUAGE
427: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_LANG_OBJ_TBL),
428: CAST(MULTISET (
429: SELECT HZ_EDUCATION_OBJ(
430: P_ACTION_TYPE,
431: NULL, -- COMMON_OBJ_ID