DBA Data[Home] [Help]

APPS.PSB_BUDGET_ACCOUNT_PVT dependencies on FND_ID_FLEX_STRUCTURES

Line 424: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;

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:

Line 425: l_application_id fnd_id_flex_structures.application_id%TYPE;

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

Line 445: FROM fnd_id_flex_structures str, fnd_id_flex_segments seg

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