APPS.FV_CFS_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;

16: v_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
17: v_currency_code gl_sets_of_books.currency_code%TYPE;
18: v_bal_seg_name VARCHAR2(20);
19: v_acc_seg_name VARCHAR2(20);
20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;

Line 21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;

17: v_currency_code gl_sets_of_books.currency_code%TYPE;
18: v_bal_seg_name VARCHAR2(20);
19: v_acc_seg_name VARCHAR2(20);
20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;

Line 260: FROM fnd_id_flex_segments_vl

256: seg_value_set_name);
257:
258: SELECT flex_value_set_id
259: INTO v_acct_flex_value_set_id
260: FROM fnd_id_flex_segments_vl
261: WHERE application_id = 101
262: AND id_flex_code = 'GL#'
263: AND id_flex_num = v_chart_of_accounts_id
264: AND enabled_flag = 'Y'

Line 291: FROM fnd_id_flex_segments_vl

287: seg_value_set_name);
288:
289: SELECT flex_value_set_id
290: INTO v_bal_flex_value_set_id
291: FROM fnd_id_flex_segments_vl
292: WHERE application_id = 101
293: AND id_flex_code = 'GL#'
294: AND id_flex_num = v_chart_of_accounts_id
295: AND enabled_flag = 'Y'

Line 336: FROM fnd_id_flex_segments

332: v_seg_str t_seg_str_table;
333:
334: CURSOR flex IS
335: SELECT application_column_name , flex_value_set_id
336: FROM fnd_id_flex_segments
337: WHERE id_flex_code = 'GL#'
338: AND application_id = 101
339: AND id_flex_num = v_chart_of_accounts_id;
340:

Line 515: FROM fnd_id_flex_segments glflex

511: l_module_name VARCHAR2(200) := g_module_name || 'build_dynamic_query';
512:
513: CURSOR flex_columns_cursor IS
514: SELECT UPPER(glflex.application_column_name) column_name, flex_value_set_id
515: FROM fnd_id_flex_segments glflex
516: WHERE glflex.application_id = 101
517: AND glflex.id_flex_num = v_chart_of_accounts_id
518: AND glflex.id_flex_code = 'GL#'
519: ORDER BY glflex.application_column_name;

Line 521: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

517: AND glflex.id_flex_num = v_chart_of_accounts_id
518: AND glflex.id_flex_code = 'GL#'
519: ORDER BY glflex.application_column_name;
520:
521: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
522: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
523: l_temp1 VARCHAR2(8000) DEFAULT '';
524: l_temp2 VARCHAR2(8000) DEFAULT '';
525: l_table_name VARCHAR2(50);

Line 522: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

518: AND glflex.id_flex_code = 'GL#'
519: ORDER BY glflex.application_column_name;
520:
521: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
522: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
523: l_temp1 VARCHAR2(8000) DEFAULT '';
524: l_temp2 VARCHAR2(8000) DEFAULT '';
525: l_table_name VARCHAR2(50);
526: l_period_name_where VARCHAR2(500);