APPS.JTF_TTY_NA_TERRGP dependencies on HZ_PARTY_SITES

Line 2836: HZ_PARTY_SITES H2

2832: p_trade_name,
2833: p_postal_code
2834: FROM HZ_PARTIES H3,
2835: HZ_LOCATIONS H1,
2836: HZ_PARTY_SITES H2
2837: WHERE h3.party_id = h2.party_id
2838: AND h2.location_id = h1.location_id
2839: AND h3.party_id = p_party_id
2840: AND h2.identifying_address_flag = 'Y';