APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_WORK_CLASS_OBJ

Line 90: SELECT HZ_WORK_CLASS_OBJ(

86: CREATION_DATE,
87: LAST_UPDATE_DATE,
88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
89: CAST(MULTISET (
90: SELECT HZ_WORK_CLASS_OBJ(
91: P_ACTION_TYPE,
92: NULL, -- COMMON_OBJ_ID
93: WORK_CLASS_ID,
94: LEVEL_OF_EXPERIENCE,

Line 106: AND WORK_CLASS_NAME = 'HZ_PARTIES') AS HZ_WORK_CLASS_OBJ_TBL))

102: LAST_UPDATE_DATE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
104: FROM HZ_WORK_CLASS
105: WHERE WORK_CLASS_ID = P_PERSON_ID
106: AND WORK_CLASS_NAME = 'HZ_PARTIES') AS HZ_WORK_CLASS_OBJ_TBL))
107: FROM HZ_EMPLOYMENT_HISTORY
108: WHERE PARTY_ID = P_PERSON_ID;
109:
110: l_debug_prefix VARCHAR2(30) := '';