eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on IGC_CC_DET_PF_V

Line 39: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

35: ) RETURN BOOLEAN
36: IS
37: l_cc_headers_rec igc_cc_headers%ROWTYPE;
38: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
39: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
40:
41: /* Contract Commitment detail payment forecast */
42: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
43: -- Performance Tuning, replaced the view igc_cc_det_pf_v

Line 43: -- Performance Tuning, replaced the view igc_cc_det_pf_v

39: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
40:
41: /* Contract Commitment detail payment forecast */
42: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
43: -- Performance Tuning, replaced the view igc_cc_det_pf_v
44: -- with igc_cc_det_pf
45: -- SELECT *
46: -- FROM igc_cc_det_pf_v
47: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 46: -- FROM igc_cc_det_pf_v

42: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
43: -- Performance Tuning, replaced the view igc_cc_det_pf_v
44: -- with igc_cc_det_pf
45: -- SELECT *
46: -- FROM igc_cc_det_pf_v
47: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
48:
49: SELECT ccdpf.ROWID,
50: ccdpf.cc_det_pf_line_id,

Line 631: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

627:
628: l_cc_headers_rec igc_cc_headers%ROWTYPE;
629: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
630: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
631: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
632: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
633: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
634:
635:

Line 719: -- Performance Tuning, replaced view igc_cc_det_pf_v with igc_cc_det_pf

715: WHERE cc_header_id = p_cc_header_id;
716:
717: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
718: IS
719: -- Performance Tuning, replaced view igc_cc_det_pf_v with igc_cc_det_pf
720: -- SELECT *
721: -- FROM igc_cc_det_pf_v
722: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
723:

Line 721: -- FROM igc_cc_det_pf_v

717: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
718: IS
719: -- Performance Tuning, replaced view igc_cc_det_pf_v with igc_cc_det_pf
720: -- SELECT *
721: -- FROM igc_cc_det_pf_v
722: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
723:
724: SELECT ccdpf.ROWID,
725: ccdpf.cc_det_pf_line_id,

Line 943: -- Performance Tuning, replaced view igc_cc_det_pf_v

939: THEN
940: l_det_pf_func_amt_total := 0;
941:
942: BEGIN
943: -- Performance Tuning, replaced view igc_cc_det_pf_v
944: -- with igc_cc_det_pf_v and replaced the
945: -- following line.
946: -- - (a.cc_det_pf_func_amt - a.cc_det_pf_func_billed_amt)
947: SELECT

Line 944: -- with igc_cc_det_pf_v and replaced the

940: l_det_pf_func_amt_total := 0;
941:
942: BEGIN
943: -- Performance Tuning, replaced view igc_cc_det_pf_v
944: -- with igc_cc_det_pf_v and replaced the
945: -- following line.
946: -- - (a.cc_det_pf_func_amt - a.cc_det_pf_func_billed_amt)
947: SELECT
948: ( ( ( a.cc_det_pf_entered_amt - IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(a.cc_det_pf_line_id, a.cc_det_pf_line_num, a.cc_acct_line_id))

Line 1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

1609: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:
1616: /*Bug No : 6341012. MOAC Uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */
1617: l_sob_id NUMBER;

Line 1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:
1616: /*Bug No : 6341012. MOAC Uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */
1617: l_sob_id NUMBER;
1618: l_org_id NUMBER;

Line 1814: -- FROM igc_cc_det_pf_v

1810:
1811: CURSOR C_PF_LINES(p_cc_acct_line_id NUMBER)
1812: IS
1813: -- SELECT *
1814: -- FROM igc_cc_det_pf_v
1815: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
1816:
1817: SELECT ccdpf.ROWID,
1818: ccdpf.cc_det_pf_line_id,

Line 2565: -- Replaced view igc_cc_det_pf_v with

2561: END;
2562:
2563:
2564: BEGIN
2565: -- Replaced view igc_cc_det_pf_v with
2566: -- igc_cc_det_pf
2567: -- (a.cc_det_pf_func_amt - a.cc_det_pf_func_billed_amt)
2568:
2569: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +