APPS.AP_VENDOR_PUB_PKG dependencies on FND_LANGUAGES

Line 2146: fnd_languages fl

2142: IF p_party_site_id IS NOT NULL THEN
2143: SELECT hl.location_id
2144: INTO x_location_id
2145: FROM HZ_Locations hl, HZ_Party_Sites hps,
2146: fnd_languages fl
2147: WHERE hl.language = fl.language_code(+) AND
2148: nvl(upper(hl.country), 'dummy') =
2149: nvl(upper(p_country), 'dummy') AND
2150: nvl(upper(hl.address1), 'dummy') =

Line 2178: fnd_languages fl

2174: INTO x_location_id, p_party_site_id
2175: FROM HZ_Locations hl,
2176: HZ_Party_Sites hps,
2177: po_vendors pv,
2178: fnd_languages fl
2179: WHERE nvl(upper(hl.country), 'dummy') =
2180: nvl(upper(p_country), 'dummy') AND
2181: nvl(upper(hl.address1), 'dummy') =
2182: nvl(upper(p_address_line1), 'dummy') AND

Line 8488: FROM fnd_languages

8484: IF l_vendor_site_rec.language IS NOT NULL THEN
8485: BEGIN
8486: SELECT language_code
8487: INTO l_location_rec.language
8488: FROM fnd_languages
8489: WHERE nls_language = l_vendor_site_rec.language;
8490: EXCEPTION
8491: WHEN OTHERS THEN
8492: l_location_rec.language := NULL;

Line 9967: FROM fnd_languages

9963: l_language VARCHAR2(10);
9964: valid_language_flag BOOLEAN := TRUE ;
9965: cursor c_lang_is IS
9966: SELECT language_code,installed_flag
9967: FROM fnd_languages
9968: WHERE nls_language = p_vendor_site_rec.language
9969: AND nvl(Installed_flag,'I') in ('I','B','D');
9970:
9971: --Bug 7835321