DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PARTY_PREF_OBJ

Line 353: SELECT HZ_PARTY_PREF_OBJ(

349: HZ_ORIG_SYS_REF_OBJ_TBL(),
350: HZ_EXT_ATTRIBUTE_OBJ_TBL(),
351: HZ_PARTY_SITE_BO_TBL(),
352: CAST(MULTISET (
353: SELECT HZ_PARTY_PREF_OBJ(
354: P_ACTION_TYPE,
355: NULL, -- COMMON_OBJ_ID
356: PARTY_PREFERENCE_ID,
357: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

Line 376: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PARTY_PREF_OBJ_TBL),

372: CREATION_DATE,
373: LAST_UPDATE_DATE,
374: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
375: FROM HZ_PARTY_PREFERENCES
376: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PARTY_PREF_OBJ_TBL),
377: HZ_RELATIONSHIP_OBJ_TBL(),
378: HZ_PHONE_CP_BO_TBL(),
379: HZ_EMAIL_CP_BO_TBL(),
380: HZ_WEB_CP_BO_TBL(),