APPS.JA_CN_UTILITY dependencies on FND_ID_FLEX_SEGMENTS

Line 1044: l_Account_Segment Fnd_Id_Flex_Segments.Segment_Name%TYPE;

1040: l_Id_Flex_Num Fnd_Id_Flex_Structures.Id_Flex_Num%TYPE;
1041: l_Delimiter Fnd_Id_Flex_Structures.Concatenated_Segment_Delimiter%TYPE;
1042: l_Seq_Account NUMBER;
1043: l_Account_Segment_Flag Fnd_Segment_Attribute_Values.Attribute_Value%TYPE;
1044: l_Account_Segment Fnd_Id_Flex_Segments.Segment_Name%TYPE;
1045:
1046: l_Cash_Related_Flag BOOLEAN;
1047: l_Cash_Acct_Count NUMBER;
1048:

Line 1062: FROM Fnd_Id_Flex_Segments

1058: WHERE Set_Of_Books_Id = p_Set_Of_Bks_Id);
1059:
1060: CURSOR c_Coa_Segments IS
1061: SELECT Application_Column_Name
1062: FROM Fnd_Id_Flex_Segments
1063: WHERE Application_Id = 101
1064: AND Id_Flex_Code = 'GL#'
1065: AND Id_Flex_Num = l_Id_Flex_Num
1066: AND Enabled_Flag = 'Y'

Line 1571: FROM FND_ID_FLEX_SEGMENTS

1567: SELECT NUM+1 INTO l_num
1568: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
1569: (SELECT ROWNUM NUM, APPLICATION_COLUMN_NAME
1570: FROM (SELECT APPLICATION_COLUMN_NAME, SEGMENT_NUM
1571: FROM FND_ID_FLEX_SEGMENTS
1572: WHERE ID_FLEX_NUM = p_coa_id
1573: AND ID_FLEX_CODE = 'GL#'
1574: AND APPLICATION_ID = 101
1575: AND ENABLED_FLAG = 'Y'

Line 2691: FROM FND_ID_FLEX_SEGMENTS FIFS,

2687: CURSOR segment_value_cur
2688: IS
2689: SELECT FFV.Flex_Value Segment_Value
2690: ,FFVT.Description Segment_Value_Description
2691: FROM FND_ID_FLEX_SEGMENTS FIFS,
2692: Fnd_Flex_Values FFV,
2693: FND_FLEX_VALUES_TL FFVT
2694: WHERE FIFS.Application_Id = 101
2695: AND FIFS.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code --parameter: pv_flexfield_code

Line 2783: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,' ;

2779:
2780: lv_cursor_sql := 'SELECT FFV.'|| Get_Attribute_Column(pv_flexfield_code
2781: ,0
2782: ,pn_coa_id) || ' Attribute_Value';
2783: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,' ;
2784: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';
2785: lv_cursor_sql := lv_cursor_sql || ' WHERE FIFS.Application_Id = 101';
2786: lv_cursor_sql := lv_cursor_sql || ' AND FIFS.Application_Column_Name = '''||Get_Attribute_Column('CPRO'
2787: ,101

Line 3082: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,';

3078: );
3079: END IF; --(ln_proc_level>=ln_dbg_level)
3080:
3081: lv_cursor_sql := 'SELECT FFV.Flex_Value Budget_Type';
3082: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,';
3083: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';
3084: lv_cursor_sql := lv_cursor_sql || ' WHERE FIFS.Application_Id = 101';
3085: lv_cursor_sql := lv_cursor_sql || ' AND FIFS.Application_Column_Name = '''||Get_Attribute_Column('CBTY'
3086: ,101