APPS.FV_SF133_ONEYEAR dependencies on FND_ID_FLEX_SEGMENTS

Line 65: c_segment_name fnd_id_flex_segments.segment_name%TYPE;

61: g_established_year NUMBER;
62: g_cancellation_year NUMBER;
63:
64: -- ---------- Flex Segment Name Cursor Variables ---------
65: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
66: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
67: --
68: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
69: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

Line 66: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

62: g_cancellation_year NUMBER;
63:
64: -- ---------- Flex Segment Name Cursor Variables ---------
65: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
66: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
67: --
68: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
69: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
70: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------

Line 68: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;

64: -- ---------- Flex Segment Name Cursor Variables ---------
65: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
66: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
67: --
68: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
69: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
70: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
71: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;

Line 130: FROM fnd_id_flex_segments glflex

126: CURSOR flex_field_column_name_cursor
127: IS
128: SELECT UPPER(glflex.segment_name) segment_name,
129: UPPER(glflex.application_column_name) flex_column_name
130: FROM fnd_id_flex_segments glflex
131: WHERE glflex.application_id = 101
132: AND glflex.id_flex_num = g_chart_of_accounts_id
133: AND glflex.id_flex_code = 'GL#'
134: ORDER BY glflex.application_column_name;

Line 482: FROM fnd_id_flex_segments

478: --
479: BEGIN
480: SELECT flex_value_set_id
481: INTO g_seg_value_set_id
482: FROM fnd_id_flex_segments
483: WHERE application_column_name = c_flex_column_name
484: AND application_id = 101
485: AND id_flex_code = 'GL#'
486: AND id_flex_num = g_chart_of_accounts_id;

Line 1471: FROM fnd_id_flex_segments

1467: )
1468: IS
1469: SELECT application_column_name ,
1470: flex_value_set_id
1471: FROM fnd_id_flex_segments
1472: WHERE id_flex_code = 'GL#'
1473: AND id_flex_num = p_chart_of_accounts_id;
1474:
1475: CURSOR child_value_cursor