DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

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'