DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_CERTIFICATION_OBJ

Line 498: SELECT HZ_CERTIFICATION_OBJ(

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
501: CERTIFICATION_ID,
502: CERTIFICATION_NAME,

Line 518: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CERTIFICATION_OBJ_TBL),

514: CREATION_DATE,
515: LAST_UPDATE_DATE,
516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
517: FROM HZ_CERTIFICATIONS
518: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CERTIFICATION_OBJ_TBL),
519: CAST(MULTISET (
520: SELECT HZ_FINANCIAL_PROF_OBJ(
521: P_ACTION_TYPE,
522: NULL, -- COMMON_OBJ_ID