APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_LOCATIONS

Line 1790: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;

1786: l_dummy VARCHAR2(1);
1787: l_debug_prefix VARCHAR2(30) := '';
1788:
1789: -- Bug 2197181
1790: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
1791: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1792: BEGIN
1793:
1794: --Initialize the created by module

Line 1804: from hz_locations

1800:
1801: -- Bug 2197181
1802: select actual_content_source
1803: into l_loc_actual_content_source
1804: from hz_locations
1805: where location_id = p_party_site_rec.location_id;
1806:
1807: /* SSM SST Integration and Extension
1808: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.

Line 1965: SELECT * FROM hz_locations

1961: p_location_id IN NUMBER
1962: ) IS
1963:
1964: CURSOR c_loc IS
1965: SELECT * FROM hz_locations
1966: WHERE location_id = p_location_id;
1967:
1968: CURSOR c_party IS
1969: SELECT 'Y'

Line 2109: p_entity_name => 'HZ_LOCATIONS',

2105: -- sources for this entity.
2106: /*
2107: IF g_pst_mixnmatch_enabled IS NULL THEN
2108: HZ_MIXNM_UTILITY.LoadDataSources(
2109: p_entity_name => 'HZ_LOCATIONS',
2110: p_entity_attr_id => g_pst_entity_attr_id,
2111: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
2112: p_selected_datasources => g_pst_selected_datasources );
2113: END IF;

Line 3352: l_country_code hz_locations.country%TYPE;

3348: l_msg_count NUMBER;
3349: l_msg_data VARCHAR2(2000);
3350:
3351: l_formatted_phone_number VARCHAR2(100);
3352: l_country_code hz_locations.country%TYPE;
3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;