DBA Data[Home] [Help]

APPS.OKS_RENEW_UTIL_PVT dependencies on XDO_TEMPLATES_B

Line 1596: FROM fnd_languages a, xdo_templates_b b

1592: CURSOR l_template_def_lang_csr (p_template_id NUMBER) IS
1593: SELECT CASE WHEN a.installed_flag = 'D' THEN 'US' ELSE a.language_code END language_code,
1594: CASE WHEN a.installed_flag = 'D' THEN 'en' ELSE b.default_language END default_language,
1595: CASE WHEN a.installed_flag = 'D' THEN '00' ELSE b.default_territory END default_territory
1596: FROM fnd_languages a, xdo_templates_b b
1597: WHERE a.iso_language = upper(b.default_language)
1598: AND b.template_id = p_template_id
1599: AND (a.iso_territory = b.default_territory
1600: OR (b.default_territory = '00' and a.installed_flag IN ('B','I','D')))