[Home] [Help]
342:
343: CURSOR get_flex_code is
344: SELECT
345: descriptive_flex_context_code
346: FROM fnd_descr_flex_contexts_vl
347: WHERE application_id = p_application_id
348: AND descriptive_flexfield_name = p_flex_name
349: AND descriptive_flex_context_name = p_region_source_name;
350:
423: IS
424:
425: CURSOR get_name IS
426: SELECT descriptive_flex_context_name
427: FROM fnd_descr_flex_contexts_vl
428: WHERE descriptive_flexfield_name = 'PA_STATUS_REPORT_DESC_FLEX'
429: AND descriptive_flex_context_code = p_context_code
430: AND application_id = fnd_global.resp_appl_id; /* Added for for Bug 2634995 */
431: