462: BEGIN
463: BEGIN
464: SELECT concatenated_segment_delimiter
465: INTO l_delimiter
466: FROM fnd_id_flex_structures
467: WHERE id_flex_code = 'MCAT'
468: AND id_flex_structure_code='WSH_COMMODITY_CODE'
469: AND application_id = 401;
470:
546: AND s.category_set_name = 'WSH_COMMODITY_CODE';
547:
548: CURSOR get_delimiter IS
549: SELECT concatenated_segment_delimiter
550: FROM fnd_id_flex_structures
551: WHERE id_flex_code = 'MCAT'
552: AND id_flex_structure_code ='WSH_COMMODITY_CODE'
553: AND application_id = 401;
554: