APPS.AP_VENDOR_PUB_PKG dependencies on FND_LANGUAGES

Line 1863: fnd_languages fl

1859: IF p_party_site_id IS NOT NULL THEN
1860: SELECT hl.location_id
1861: INTO x_location_id
1862: FROM HZ_Locations hl, HZ_Party_Sites hps,
1863: fnd_languages fl
1864: WHERE hl.language = fl.language_code(+) AND
1865: nvl(upper(hl.country), 'dummy') =
1866: nvl(upper(p_country), 'dummy') AND
1867: nvl(upper(hl.address1), 'dummy') =

Line 1894: fnd_languages fl

1890: INTO x_location_id, p_party_site_id
1891: FROM HZ_Locations hl,
1892: HZ_Party_Sites hps,
1893: po_vendors pv,
1894: fnd_languages fl
1895: WHERE nvl(upper(hl.country), 'dummy') =
1896: nvl(upper(p_country), 'dummy') AND
1897: nvl(upper(hl.address1), 'dummy') =
1898: nvl(upper(p_address_line1), 'dummy') AND

Line 7512: FROM fnd_languages

7508: IF l_vendor_site_rec.language IS NOT NULL THEN
7509: BEGIN
7510: SELECT language_code
7511: INTO l_location_rec.language
7512: FROM fnd_languages
7513: WHERE nls_language = l_vendor_site_rec.language;
7514: EXCEPTION
7515: WHEN OTHERS THEN
7516: l_location_rec.language := NULL;