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 213: FROM fnd_id_flex_segments glflex

209: CURSOR flex_field_column_name_cursor
210: IS
211: SELECT UPPER(glflex.segment_name) segment_name,
212: UPPER(glflex.application_column_name) flex_column_name
213: FROM fnd_id_flex_segments glflex
214: WHERE glflex.application_id = 101
215: AND glflex.id_flex_num = g_chart_of_accounts_id
216: AND glflex.id_flex_code = 'GL#'
217: ORDER BY glflex.application_column_name;

Line 653: FROM fnd_id_flex_segments

649: --
650: BEGIN
651: SELECT flex_value_set_id
652: INTO g_seg_value_set_id
653: FROM fnd_id_flex_segments
654: WHERE application_column_name = c_flex_column_name
655: AND application_id = 101
656: AND id_flex_code = 'GL#'
657: AND id_flex_num = g_chart_of_accounts_id;

Line 1969: FROM fnd_id_flex_segments

1965: )
1966: IS
1967: SELECT application_column_name ,
1968: flex_value_set_id
1969: FROM fnd_id_flex_segments
1970: WHERE id_flex_code = 'GL#'
1971: AND id_flex_num = p_chart_of_accounts_id;
1972:
1973: CURSOR child_value_cursor