432:
433: l_cc_headers_rec igc_cc_headers%ROWTYPE;
434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
437:
438: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
439: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
440:
521:
522: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
523: IS
524: -- SELECT *
525: -- FROM igc_cc_det_pf_v
526: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
527:
528: SELECT ccdpf.ROWID,
529: ccdpf.cc_det_pf_line_id,
1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1594: l_err_header_id NUMBER;
1595: l_err_acct_line_id NUMBER;
1596: l_err_det_pf_line_id NUMBER;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1594: l_err_header_id NUMBER;
1595: l_err_acct_line_id NUMBER;
1596: l_err_det_pf_line_id NUMBER;
1597:
1849:
1850: CURSOR C_PF_LINES(p_cc_acct_line_id NUMBER)
1851: IS
1852: -- SELECT *
1853: -- FROM igc_cc_det_pf_v
1854: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
1855:
1856: SELECT ccdpf.ROWID,
1857: ccdpf.cc_det_pf_line_id,
3364: END;
3365:
3366:
3367: BEGIN
3368: -- Replaced the view igc_cc_det_pf_v with
3369: -- igc_cc_det_pf.
3370: -- Also replaced the following line.
3371: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3372:
3453: END;
3454:
3455:
3456: BEGIN
3457: -- Replaced view igc_cc_det_pf_v with
3458: -- igc_cc_det_pf. Also replaced the following
3459: -- line.
3460: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3461: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +
3546:
3547:
3548: BEGIN
3549:
3550: -- Replaced the view igc_cc_det_pf_v with
3551: -- igc_cc_det_pf and replaced the
3552: -- following line.
3553: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3554: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +