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 691: FROM fv_cfs_rep_line_dtl d,

687: segment27 ,
688: segment28 ,
689: segment29 ,
690: segment30
691: FROM fv_cfs_rep_line_dtl d,
692: fv_cfs_rep_lines L
693: WHERE l.report_type = v_report_type
694: AND d.line_id = l.line_id
695: AND l.set_of_books_id = v_sob

Line 992: FROM fv_cfs_rep_line_dtl dets,

988: v_fct1_attr_select :=
989: ' SELECT SUM(NVL(DECODE(:cv_balance_type,
990: ''B'', ROUND(NVL(fctbal.begin_balance,0),2),
991: ''E'', ROUND(NVL(fctbal.balance_amount,0))),0) )
992: FROM fv_cfs_rep_line_dtl dets,
993: fv_ccid_cfs_gt fvcc,
994: fv_facts1_period_attributes fctbal
995: WHERE dets.line_id = :cv_line_id
996: AND dets.line_detail_id = :cv_line_detail_id

Line 1025: fv_cfs_rep_line_dtl dets,

1021: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
1022: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';
1023: l_temp1 := '
1024: FROM fv_ccid_cfs_gt fvcc,
1025: fv_cfs_rep_line_dtl dets,
1026: fv_facts1_period_balances_v ffrt
1027: WHERE dets.line_id = :cv_line_id
1028: AND dets.line_detail_id = :cv_line_detail_id
1029: AND dets.line_detail_id = fvcc.detail_id

Line 1074: FROM fv_cfs_rep_line_dtl dets,

1070: ''E'', ROUND(NVL(SUM((NVL(glbal.begin_balance_dr,0) -
1071: NVL(glbal.begin_balance_cr,0)) +
1072: (NVL(glbal.period_net_dr,0) -
1073: NVL(glbal.period_net_cr,0))),0),2)),0)
1074: FROM fv_cfs_rep_line_dtl dets,
1075: fv_ccid_cfs_gt fvcc,
1076: gl_code_combinations glc,
1077: gl_balances glbal
1078: WHERE dets.line_id = :cv_line_id

Line 1163: FROM fv_cfs_rep_line_dtl

1159: IF lines_rec.line_type IN ('D', 'D2') THEN
1160: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
1161: SELECT COUNT(*)
1162: INTO l_line_cnt
1163: FROM fv_cfs_rep_line_dtl
1164: WHERE line_id = v_line_id;
1165: IF l_line_cnt = 0 THEN
1166: NULL;
1167: populate_temp_table;

Line 1416: FROM fv_cfs_rep_line_dtl

1412: || '.'
1413: || segment29
1414: || '.'
1415: || segment30 concatenated_segments
1416: FROM fv_cfs_rep_line_dtl
1417: WHERE line_id = v_line_id;
1418:
1419: TYPE l_recipient_rec_type
1420: IS