APPS.PV_SQL_UTILITY dependencies on HZ_LOCATIONS

Line 407: FROM hz_locations a,

403: RETURN NULL;
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

Line 780: FROM hz_locations a,

776: NULL,
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')

Line 840: FROM hz_locations

836: NULL,
837: 2000,
838: 1,
839: 1) ADDRESS
840: FROM hz_locations
841: WHERE location_id = p_location_id)
842: LOOP
843: l_formatted_address := x.address;
844: END LOOP;