APPS.PON_ATTR_MAPPING dependencies on HZ_PARTY_SITES

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)

Line 50: FROM hz_party_sites hzps, hz_party_site_uses hzpsu

46:
47: CURSOR ap_cursor(x_party_id NUMBER, x_vendor_id NUMBER)
48: IS
49: SELECT 'AP:' || site_use_type AS Code
50: FROM hz_party_sites hzps, hz_party_site_uses hzpsu
51: WHERE hzps.party_id = x_party_id
52: AND hzpsu.party_site_id = hzps.party_site_id
53: AND hzpsu.status = 'A'
54: UNION