APPS.PV_SQL_UTILITY dependencies on HZ_PARTY_SITES

Line 408: hz_party_sites b

404: END IF;
405:
406: FOR x IN (SELECT country meaning
407: FROM hz_locations a,
408: hz_party_sites b
409: WHERE b.party_site_id = p_party_site_id AND
410: a.location_id = b.location_id)
411: LOOP
412: l_meaning := x.meaning;

Line 781: hz_party_sites b

777: 2000,
778: 1,
779: 1) ADDRESS
780: FROM hz_locations a,
781: hz_party_sites b
782: WHERE b.party_site_id = p_party_site_id AND
783: a.location_id = b.location_id AND
784: b.status = 'A')
785: LOOP