APPS.WF_PREF dependencies on WF_LANGUAGES

Line 173: FROM wf_languages

169: l_row_count NUMBER := 0;
170:
171: CURSOR c_lang_lov (c_find_criteria IN VARCHAR2) IS
172: SELECT nls_language, nls_territory, code
173: FROM wf_languages
174: WHERE nls_language like c_find_criteria
175: AND installed_flag = 'Y'
176: ORDER BY nls_language;
177:

Line 186: FROM wf_languages

182: IF (p_titles_only = 'N') THEN
183:
184: SELECT COUNT(*)
185: INTO l_row_count
186: FROM wf_languages
187: WHERE nls_language like p_find_criteria||'%'
188: AND installed_flag = 'Y';
189:
190: END IF;

Line 252: FROM wf_languages

248: SELECT
249: nls_territory,
250: nls_language,
251: code
252: FROM wf_languages
253: WHERE nls_territory like c_find_criteria
254: AND installed_flag = 'Y'
255: ORDER BY nls_language;
256:

Line 266: FROM wf_languages

262: IF (p_titles_only = 'N') THEN
263:
264: SELECT COUNT(*)
265: INTO l_row_count
266: FROM wf_languages
267: WHERE nls_territory like p_find_criteria||'%'
268: AND installed_flag = 'Y';
269:
270: END IF;

Line 508: FROM wf_languages

504: IF (p_language IS NOT NULL) THEN
505:
506: SELECT count(*)
507: INTO l_row_count
508: FROM wf_languages
509: WHERE nls_language = p_language
510: AND installed_flag = 'Y';
511:
512: ELSE

Line 525: FROM wf_languages

521: AND p_territory IS NOT NULL) THEN
522:
523: SELECT count(*)
524: INTO l_combo_count
525: FROM wf_languages
526: WHERE nls_language = p_language
527: AND nls_territory = p_territory
528: AND installed_flag = 'Y';
529:

Line 559: FROM wf_languages

555: IF (p_territory IS NOT NULL) THEN
556:
557: SELECT count(*)
558: INTO l_row_count
559: FROM wf_languages
560: WHERE nls_territory = p_territory
561: AND installed_flag = 'Y';
562:
563: ELSE