420: FUNCTION Get_Active_Segments( p_chart_of_accounts_id IN NUMBER )
421: RETURN BOOLEAN
422: IS
423: /* Start bug #4924031 */
424: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
425: l_application_id fnd_id_flex_structures.application_id%TYPE;
426: l_yes_flag VARCHAR2(1);
427: /* End bug #4924031 */
428:
421: RETURN BOOLEAN
422: IS
423: /* Start bug #4924031 */
424: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
425: l_application_id fnd_id_flex_structures.application_id%TYPE;
426: l_yes_flag VARCHAR2(1);
427: /* End bug #4924031 */
428:
429: BEGIN
441:
442: FOR l_flex_rec IN
443: (
444: SELECT seg.application_column_name
445: FROM fnd_id_flex_structures str, fnd_id_flex_segments seg
446: WHERE str.application_id = l_application_id -- bug #4924031
447: AND str.id_flex_code = l_id_flex_code -- bug #4924031
448: AND str.id_flex_num = p_chart_of_accounts_id
449: AND str.id_flex_code = seg.id_flex_code