APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HZ_LOCATIONS

Line 3073: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt

3069: WHERE payment_id = p_payment_id;
3070:
3071: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
3072: SELECT loc.language, loc.country
3073: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt
3074: WHERE payment_id = p_payment_id
3075: AND pmt.party_site_id = ps.party_site_id(+)
3076: AND loc.location_id = ps.location_id;
3077: