APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_LANGUAGES

Line 4281: --Adding fnd_languages table to fetch language country in

4277: FROM iby_payments_all
4278: WHERE payment_id = p_payment_id;
4279:
4280: --Changing for bug 9686312.
4281: --Adding fnd_languages table to fetch language country in
4282: --ISO standard.
4283: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
4284: SELECT fl.language_code , loc.country
4285: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt

Line 4286: , fnd_languages fl

4282: --ISO standard.
4283: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
4284: SELECT fl.language_code , loc.country
4285: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt
4286: , fnd_languages fl
4287: WHERE payment_id = p_payment_id
4288: AND fl.language_code = loc.language
4289: AND pmt.party_site_id = ps.party_site_id(+)
4290: AND loc.location_id = ps.location_id;