DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on GL_CODE_COMBINATIONS

Line 31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;

27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 32: v_account gl_code_combinations.segment1%TYPE;

28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 33: v_fund gl_code_combinations.segment1%TYPE;

29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 483: || ' from gl_code_combinations WHERE ' || v_statement

479: ccid)
480: select ' ||
481: crec_rec.line_detail_id
482: || ', code_combination_id '
483: || ' from gl_code_combinations WHERE ' || v_statement
484: || ' and template_id is null and '
485: || ' chart_of_accounts_id = :B_CHART_OF_ACCOUNTS_ID
486: and not exists (select code_combination_id
487: from fv_ccid_CFS_GT FCT '

Line 639: gl_code_combinations glc,

635: (NVL(glbal.period_net_dr,0) -
636: NVL(glbal.period_net_cr,0))),0),2)),0)
637: FROM fv_cfs_rep_line_dtl dets,
638: fv_ccid_cfs_gt fvcc,
639: gl_code_combinations glc,
640: gl_balances glbal
641: WHERE dets.line_id = :cv_line_id
642: AND dets.line_detail_id = :cv_line_detail_id
643: AND dets.line_detail_id = fvcc.detail_id

Line 934: l_account_number gl_code_combinations.segment1%TYPE;

930: l_log_mesg VARCHAR2(32000) := '';
931: l_conc_segs VARCHAR2(32000);
932: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
933: l_account_type VARCHAR2(1) := '';
934: l_account_number gl_code_combinations.segment1%TYPE;
935: l_balance_determined NUMBER;
936: l_prev_year_gl_balance NUMBER;
937: l_curr_year_gl_balance NUMBER;
938: l_e_ne_ind fv_facts_attributes.exch_non_exch%TYPE := NULL;