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

146: CURSOR flex_field_column_name_cursor
147: IS
148: SELECT UPPER(glflex.segment_name) segment_name,
149: UPPER(glflex.application_column_name) flex_column_name
150: FROM fnd_id_flex_segments glflex
151: WHERE glflex.application_id = 101
152: AND glflex.id_flex_num = g_chart_of_accounts_id
153: AND glflex.id_flex_code = 'GL#'
154: ORDER BY glflex.application_column_name;

Line 569: FROM fnd_id_flex_segments

565:
566: BEGIN
567: SELECT flex_value_set_id
568: INTO g_seg_value_set_id
569: FROM fnd_id_flex_segments
570: WHERE application_column_name = c_flex_column_name
571: AND application_id = 101
572: AND id_flex_code = 'GL#'
573: AND id_flex_num = g_chart_of_accounts_id;

Line 1578: FROM fnd_id_flex_segments

1574: )
1575: IS
1576: SELECT application_column_name ,
1577: flex_value_set_id
1578: FROM fnd_id_flex_segments
1579: WHERE id_flex_code = 'GL#'
1580: AND id_flex_num = p_chart_of_accounts_id;
1581:
1582: CURSOR child_value_cursor