DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_PARTY_PREF_OBJ

Line 433: SELECT HZ_PARTY_PREF_OBJ(

429: HZ_EXT_ATTRIBUTE_OBJ_TBL(),
430: HZ_ORG_CONTACT_BO_TBL(),
431: HZ_PARTY_SITE_BO_TBL(),
432: CAST(MULTISET (
433: SELECT HZ_PARTY_PREF_OBJ(
434: P_ACTION_TYPE,
435: NULL, -- COMMON_OBJ_ID
436: PARTY_PREFERENCE_ID,
437: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

Line 456: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_PARTY_PREF_OBJ_TBL),

452: CREATION_DATE,
453: LAST_UPDATE_DATE,
454: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
455: FROM HZ_PARTY_PREFERENCES
456: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_PARTY_PREF_OBJ_TBL),
457: HZ_PHONE_CP_BO_TBL(),
458: HZ_TELEX_CP_BO_TBL(),
459: HZ_EMAIL_CP_BO_TBL(),
460: HZ_WEB_CP_BO_TBL(),