APPS.PON_ATTR_MAPPING dependencies on HZ_LOCATIONS

Line 43: FROM hz_locations hzl, hz_party_sites hzps

39:
40: CURSOR ac_cursor(x_party_id NUMBER)
41: IS
42: SELECT DISTINCT 'AC:'||hzl.country AS Code
43: FROM hz_locations hzl, hz_party_sites hzps
44: WHERE hzps.party_id = x_party_id
45: AND hzl.location_id = hzps.location_id;
46:
47: CURSOR ap_cursor(x_party_id NUMBER, x_vendor_id NUMBER)