APPS.BSC_UPDATE_UTIL dependencies on FND_LANGUAGES

Line 2579: ' FROM FND_LANGUAGES'||

2575:
2576: /*
2577: c_languages t_cursor; -- h_inst_lang, h_base_lang
2578: c_languages_sql VARCHAR2(2000) := 'SELECT DISTINCT LANGUAGE_CODE'||
2579: ' FROM FND_LANGUAGES'||
2580: ' WHERE INSTALLED_FLAG IN (:1, :2)';
2581: */
2582: CURSOR c_languages (p_param1 VARCHAR2, p_param2 VARCHAR2) IS
2583: SELECT DISTINCT LANGUAGE_CODE

Line 2584: FROM FND_LANGUAGES

2580: ' WHERE INSTALLED_FLAG IN (:1, :2)';
2581: */
2582: CURSOR c_languages (p_param1 VARCHAR2, p_param2 VARCHAR2) IS
2583: SELECT DISTINCT LANGUAGE_CODE
2584: FROM FND_LANGUAGES
2585: WHERE INSTALLED_FLAG IN (p_param1, p_param2);
2586:
2587: h_inst_lang VARCHAR2(1);
2588: h_base_lang VARCHAR2(1);

Line 4470: C.CALENDAR_ID = P.CALENDAR_ID) CA, FND_LANGUAGES L WHERE L.INSTALLED_FLAG <> 'D';

4466: BSC_SYS_PERIODICITIES P
4467: WHERE
4468: P.CALENDAR_ID = x_calendar_id AND
4469: P.PERIODICITY_TYPE = 9 AND
4470: C.CALENDAR_ID = P.CALENDAR_ID) CA, FND_LANGUAGES L WHERE L.INSTALLED_FLAG <> 'D';
4471:
4472:
4473: -- B. LABELS FOR CUSTOM PERIODICITIES
4474: --OPEN c_custom_pers FOR c_custom_pers_sql USING x_calendar_id, 0;

Line 4498: FND_LANGUAGES L

4494: C.CALENDAR_MONTH||'';''||C.CALENDAR_DAY AS NAME,
4495: NULL AS SHORT_NAME
4496: FROM
4497: BSC_DB_CALENDAR C,
4498: FND_LANGUAGES L
4499: WHERE
4500: L.INSTALLED_FLAG <> ''D'' AND
4501: C.CALENDAR_ID = :2 AND
4502: TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY,''YYYY-MM-DD'') =