APPS.CSI_UTILITY_GRP dependencies on HZ_PARTY_SITES

Line 1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz

1844: hz.address_style,
1845: hz.address_lines_phonetic,
1846: hz.county,
1847: hz.province
1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz
1849: WHERE hp.party_id = hzp.party_id
1850: AND hzp.party_site_id = cp_location_id
1851: AND hzp.location_id = hz.location_id ;
1852:

Line 1949: IF l_location_type_code = 'HZ_PARTY_SITES' THEN

1945: l_location_type_code := NULL; -- l_ib_instance.location_type_code;
1946: l_location_id := NULL; -- l_ib_instance.location_id ;
1947: END IF;
1948:
1949: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
1950:
1951: OPEN c_party_address( l_location_id );
1952: FETCH c_party_address INTO l_party_address ;
1953: