APPS.AP_VENDOR_PUB_PKG dependencies on HZ_LOCATIONS

Line 1862: FROM HZ_Locations hl, HZ_Party_Sites hps,

1858: --Open Issue 2 should they match if they are null?
1859: IF p_party_site_id IS NOT NULL THEN
1860: SELECT hl.location_id
1861: INTO x_location_id
1862: FROM HZ_Locations hl, HZ_Party_Sites hps,
1863: fnd_languages fl
1864: WHERE hl.language = fl.language_code(+) AND
1865: nvl(upper(hl.country), 'dummy') =
1866: nvl(upper(p_country), 'dummy') AND

Line 1891: FROM HZ_Locations hl,

1887: ELSE
1888:
1889: SELECT hl.location_id, hps.party_site_id
1890: INTO x_location_id, p_party_site_id
1891: FROM HZ_Locations hl,
1892: HZ_Party_Sites hps,
1893: po_vendors pv,
1894: fnd_languages fl
1895: WHERE nvl(upper(hl.country), 'dummy') =

Line 2412: FROM hz_locations hl, hz_party_sites hps

2408: x_valid := TRUE;
2409:
2410: SELECT Count(*)
2411: INTO l_dummy
2412: FROM hz_locations hl, hz_party_sites hps
2413: WHERE hl.location_id = p_location_id
2414: AND hl.location_id = hps.location_id
2415: AND hps.party_site_id = nvl(p_party_site_id, hps.party_site_id);
2416: