APPS.FV_CFS_PKG dependencies on FV_CFS_REP_LINE_DTL

Line 23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;

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;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;

Line 104: v_balance_type fv_cfs_rep_line_dtl.balance_type%TYPE;

100: v_py_sbr_beg_bal NUMBER;
101: v_py_sbr_end_bal NUMBER;
102:
103:
104: v_balance_type fv_cfs_rep_line_dtl.balance_type%TYPE;
105:
106: -- =============================================================
107: PROCEDURE get_qualifier_segments;
108: PROCEDURE build_dynamic_query;

Line 359: FROM fv_cfs_rep_line_dtl d,

355: segment17, segment18, segment19, segment20,
356: segment21, segment22, segment23, segment24,
357: segment25, segment26, segment27, segment28,
358: segment29, segment30
359: FROM fv_cfs_rep_line_dtl d,
360: fv_cfs_rep_lines L
361: WHERE l.report_type = v_report_type
362: AND d.line_id = l.line_id
363: AND l.set_of_books_id = v_sob

Line 538: FROM fv_cfs_rep_line_dtl dets,

534: v_fct1_attr_select :=
535: ' SELECT SUM(NVL(DECODE(:cv_balance_type,
536: ''B'', ROUND(NVL(fctbal.begin_balance,0),2),
537: ''E'', ROUND(NVL(fctbal.balance_amount,0))),0) )
538: FROM fv_cfs_rep_line_dtl dets,
539: fv_ccid_cfs_gt fvcc,
540: fv_facts1_period_attributes fctbal
541: WHERE dets.line_id = :cv_line_id
542: AND dets.line_detail_id = :cv_line_detail_id

Line 578: fv_cfs_rep_line_dtl dets,

574: v_fct1_sel || ' , ffrt.recipient_name ';
575:
576: l_temp1 := '
577: FROM fv_ccid_cfs_gt fvcc,
578: fv_cfs_rep_line_dtl dets,
579: fv_facts1_period_balances_v ffrt
580: WHERE dets.line_id = :cv_line_id
581: AND dets.line_detail_id = :cv_line_detail_id
582: AND dets.line_detail_id = fvcc.detail_id

Line 637: FROM fv_cfs_rep_line_dtl dets,

633: ''E'', ROUND(NVL(SUM((NVL(glbal.begin_balance_dr,0) -
634: NVL(glbal.begin_balance_cr,0)) +
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

Line 720: FROM fv_cfs_rep_line_dtl

716: IF lines_rec.line_type IN ('D', 'D2') THEN
717: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
718: SELECT count(*)
719: INTO l_line_cnt
720: FROM fv_cfs_rep_line_dtl
721: WHERE line_id = v_line_id;
722: IF l_line_cnt = 0 THEN NULL;
723: populate_temp_table;
724: ELSE

Line 893: FROM fv_cfs_rep_line_dtl

889: segment16 || '.' || segment17 || '.' || segment18 || '.' || segment19 || '.' || segment20 || '.' ||
890: segment21 || '.' || segment22 || '.' || segment23 || '.' || segment24 || '.' || segment25 || '.' ||
891: segment26 || '.' || segment27 || '.' || segment28 || '.' || segment29 || '.' || segment30
892: concatenated_segments
893: FROM fv_cfs_rep_line_dtl
894: WHERE line_id = v_line_id;
895:
896: TYPE l_recipient_rec_type IS RECORD (
897: recipient_name fv_facts_report_t2.recipient_name%TYPE,