APPS.AP_VENDOR_PUB_PKG dependencies on HZ_LOCATIONS

Line 2145: FROM HZ_Locations hl, HZ_Party_Sites hps,

2141: --Open Issue 2 should they match if they are null?
2142: IF p_party_site_id IS NOT NULL THEN
2143: SELECT hl.location_id
2144: INTO x_location_id
2145: FROM HZ_Locations hl, HZ_Party_Sites hps,
2146: fnd_languages fl
2147: WHERE hl.language = fl.language_code(+) AND
2148: nvl(upper(hl.country), 'dummy') =
2149: nvl(upper(p_country), 'dummy') AND

Line 2175: FROM HZ_Locations hl,

2171: ELSE
2172:
2173: SELECT hl.location_id, hps.party_site_id
2174: INTO x_location_id, p_party_site_id
2175: FROM HZ_Locations hl,
2176: HZ_Party_Sites hps,
2177: po_vendors pv,
2178: fnd_languages fl
2179: WHERE nvl(upper(hl.country), 'dummy') =

Line 2723: FROM hz_locations hl, hz_party_sites hps

2719: x_valid := TRUE;
2720:
2721: SELECT Count(*)
2722: INTO l_dummy
2723: FROM hz_locations hl, hz_party_sites hps
2724: WHERE hl.location_id = p_location_id
2725: AND hl.location_id = hps.location_id
2726: AND hps.party_site_id = nvl(p_party_site_id, hps.party_site_id);
2727: