APPS.FV_SF133_NOYEAR dependencies on FND_ID_FLEX_SEGMENTS

Line 56: c_segment_name fnd_id_flex_segments.segment_name%TYPE;

52: c_resource_type fv_treasury_symbols.resource_type%TYPE;
53: c_rescission_flag Varchar2(10);
54:
55: -- ---------- Flex Segment Name Cursor Variables ---------
56: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
57: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
58: --
59: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
60: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

Line 57: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

53: c_rescission_flag Varchar2(10);
54:
55: -- ---------- Flex Segment Name Cursor Variables ---------
56: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
57: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
58: --
59: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
60: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
61:

Line 59: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;

55: -- ---------- Flex Segment Name Cursor Variables ---------
56: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
57: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
58: --
59: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
60: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
61:
62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;

Line 113: FROM fnd_id_flex_segments glflex

109: CURSOR flex_field_column_name_cursor
110: IS
111: SELECT UPPER(glflex.segment_name) segment_name,
112: UPPER(glflex.application_column_name) flex_column_name
113: FROM fnd_id_flex_segments glflex
114: WHERE glflex.application_id = 101
115: AND glflex.id_flex_num = g_chart_of_accounts_id
116: AND glflex.id_flex_code = 'GL#'
117: ORDER BY glflex.application_column_name;

Line 454: FROM fnd_id_flex_segments

450:
451: BEGIN
452: SELECT flex_value_set_id
453: INTO g_seg_value_set_id
454: FROM fnd_id_flex_segments
455: WHERE application_column_name = c_flex_column_name
456: AND application_id = 101
457: AND id_flex_code = 'GL#'
458: AND id_flex_num = g_chart_of_accounts_id;

Line 1101: FROM fnd_id_flex_segments

1097: )
1098: IS
1099: SELECT application_column_name ,
1100: flex_value_set_id
1101: FROM fnd_id_flex_segments
1102: WHERE id_flex_code = 'GL#'
1103: AND id_flex_num = p_chart_of_accounts_id;
1104:
1105: CURSOR child_value_cursor