APPS.HZ_EXTRACT_PARTY_SITE_BO_PVT dependencies on HZ_LOCATIONS

Line 69: Location Y N HZ_LOCATIONS

65: the Get procedure returns all records for the particular party site from these TCA entity tables:
66:
67: Embedded TCA Entity Mandatory Multiple TCA Table Entities
68:
69: Location Y N HZ_LOCATIONS
70: Party Site Y N HZ_PARTY_SITES
71: Party Site Use N Y HZ_PARTY_SITE_USES
72: Contact Preference N Y HZ_CONTACT_PREFERENCES
73: */

Line 307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID

303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF
305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
306: AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID
308: AND ((P_PARTY_SITE_ID IS NULL AND PARTY_ID = P_PARTY_ID)
309: OR (P_PARTY_SITE_ID IS NOT NULL AND PARTY_SITE_ID = P_PARTY_SITE_ID));
310:
311:

Line 421: p_owner_table_name => 'HZ_LOCATIONS',

417: -- SSM for location obj
418: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
419: (p_init_msg_list => fnd_api.g_false,
420: p_owner_table_id => x_party_site_objs(i).location_obj.location_id,
421: p_owner_table_name => 'HZ_LOCATIONS',
422: p_action_type => NULL, --p_action_type,
423: x_orig_sys_ref_objs => x_party_site_objs(i).location_obj.orig_sys_objs,
424: x_return_status => x_return_status,
425: x_msg_count => x_msg_count,

Line 437: p_ext_object_name => 'HZ_LOCATIONS',

433:
434: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
435: (p_init_msg_list => fnd_api.g_false,
436: p_ext_object_id => x_party_site_objs(i).location_obj.location_id,
437: p_ext_object_name => 'HZ_LOCATIONS',
438: p_action_type => p_action_type,
439: x_ext_attribute_objs => x_party_site_objs(i).location_obj.ext_attributes_objs,
440: x_return_status => x_return_status,
441: x_msg_count => x_msg_count,