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_MPFS_PROCESS_PKG dependencies on IGC_CC_ACCT_LINES_V

Line 1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1095: )
1096: RETURN VARCHAR2
1097: IS
1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;
1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1103: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;

Line 1110: -- igc_cc_acct_lines_v with table igc_cc_acct_lines

1106: -- Cursors c_acct_lines and c_det_pf_lines
1107: -- modified for bug 2876467
1108: -- ccdpf.cc_det_pf_billed_amt changed to ccdpf.cc_det_pf_func_billed_amt
1109: -- Performance Tuning project. Replaced selection from views
1110: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1111: -- and igc_cc_det_pf_v with igc_cc_det_pf
1112: -- Replaced the following line as well
1113: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1114: CURSOR c_acct_lines(p_cc_header_id NUMBER)

Line 1117: -- FROM igc_cc_acct_lines_v ccal

1113: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1114: CURSOR c_acct_lines(p_cc_header_id NUMBER)
1115: IS
1116: -- SELECT *
1117: -- FROM igc_cc_acct_lines_v ccal
1118: -- WHERE ccal.cc_header_id = p_cc_header_id
1119: -- AND exists
1120: -- ( Select 'x' FROM igc_cc_det_pf_v ccdpf
1121: -- WHERE ccdpf.cc_acct_line_id = ccal.cc_acct_line_id

Line 1969: -- igc_cc_acct_lines_v with table igc_cc_acct_lines

1965: /* Bug No : 6341012. MOAC uptake. Local variable SOB_Name added*/
1966: l_sob_name VARCHAR2(30);
1967:
1968: -- Performance Tuning project. Replaced selection from views
1969: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1970: -- and igc_cc_det_pf_v with igc_cc_det_pf
1971: -- Replaced the following 2 lines a well
1972: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
1973: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0

Line 2018: -- igc_cc_acct_lines_v with table igc_cc_acct_lines

2014: ) > 0
2015: GROUP BY cchd.cc_header_id, cchd.cc_apprvl_status;
2016:
2017: -- Performance Tuning project. Replaced selection from views
2018: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2019: -- and igc_cc_det_pf_v with igc_cc_det_pf
2020: -- Replaced the following 2 lines a well
2021: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
2022: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0

Line 2075: -- igc_cc_acct_lines_v with table igc_cc_acct_lines

2071: AND ccpd.process_type = l_process_type
2072: AND (ccpd.processed <> 'Y' OR ccpd.processed IS NULL);
2073:
2074: -- Performance Tuning project. Replaced selection from views
2075: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2076: -- and igc_cc_det_pf_v with igc_cc_det_pf
2077: -- Replaced the following line as well
2078: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
2079: CURSOR c4 (

Line 2176: -- FROM igc_cc_acct_lines_v ccal1

2172: -- WHERE cchd.cc_header_id = p_cc_header_id
2173: -- AND cchd.org_id = p_org_id
2174: -- AND cchd.set_of_books_id = p_sob_id
2175: -- AND NOT EXISTS (SELECT 'X'
2176: -- FROM igc_cc_acct_lines_v ccal1
2177: -- WHERE ccal1.cc_header_id = cchd.cc_header_id
2178: -- AND NOT EXISTS (SELECT 'X'
2179: -- FROM igc_cc_det_pf_v ccdpf1
2180: -- WHERE ccdpf1.cc_acct_line_id = ccal1.cc_acct_line_id