[Home] [Help]
470: FROM HZ_CITIZENSHIP
471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),
472: HZ_EMPLOY_HIST_BO_TBL(),
473: CAST(MULTISET (
474: SELECT HZ_PERSON_INTEREST_OBJ(
475: P_ACTION_TYPE,
476: NULL, -- COMMON_OBJ_ID
477: PERSON_INTEREST_ID,
478: LEVEL_OF_INTEREST,
492: CREATION_DATE,
493: LAST_UPDATE_DATE,
494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
495: FROM HZ_PERSON_INTEREST
496: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_INTEREST_OBJ_TBL),
497: CAST(MULTISET (
498: SELECT HZ_CERTIFICATION_OBJ(
499: P_ACTION_TYPE,
500: NULL, -- COMMON_OBJ_ID