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

Line 435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

431: IS
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;

Line 446: -- view igc_cc_acct_lines_v. Instead of selecting from the view,

442: IS
443: -- Replaced the folllowing query with the one below for
444: -- performance tuning fixes.
445: -- The record definition of l_cc_acct_lines_rec is still based on
446: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
447: -- select is being done from the base table, but all the columns
448: -- as defined in the view are retained even though they are not used.
449: -- This is just so that minimal change is made to the code.
450: /*

Line 452: FROM igc_cc_acct_lines_v

448: -- as defined in the view are retained even though they are not used.
449: -- This is just so that minimal change is made to the code.
450: /*
451: SELECT *
452: FROM igc_cc_acct_lines_v
453: WHERE cc_header_id = p_cc_header_id;
454: */
455:
456: SELECT ccal.ROWID,

Line 1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1586: p_cc_header_id IN NUMBER)
1587: IS
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;

Line 1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1587: IS
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;

Line 1774: -- view igc_cc_acct_lines_v. Instead of selecting from the view,

1770: IS
1771: -- Replaced the folllowing query with the one below for
1772: -- performance tuning fixes.
1773: -- The record definition of l_cc_acct_lines_rec is still based on
1774: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
1775: -- select is being done from the base table, but all the columns
1776: -- as defined in the view are retained even though they are not used.
1777: -- This is just so that minimal change is made to the code.
1778: /*

Line 1780: FROM igc_cc_acct_lines_v

1776: -- as defined in the view are retained even though they are not used.
1777: -- This is just so that minimal change is made to the code.
1778: /*
1779: SELECT *
1780: FROM igc_cc_acct_lines_v
1781: WHERE cc_header_id = p_cc_header_id;
1782: */
1783:
1784: SELECT ccal.ROWID,

Line 3083: --FROM igc_cc_acct_lines_v a,

3079: ) * (l_rate - b.conversion_rate )
3080: )
3081: )
3082: INTO l_reval_acct_amt_total
3083: --FROM igc_cc_acct_lines_v a,
3084: FROM igc_cc_acct_lines a,
3085: igc_cc_headers b
3086: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3087: a.cc_header_id = b.cc_header_id AND

Line 3169: --FROM igc_cc_acct_lines_v a,

3165: ) * (l_rate - b.conversion_rate )
3166: )
3167: )
3168: INTO l_reval_acct_amt_total
3169: --FROM igc_cc_acct_lines_v a,
3170: FROM igc_cc_acct_lines a,
3171: igc_cc_headers b
3172: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3173: a.cc_header_id = b.cc_header_id AND

Line 3250: --FROM igc_cc_acct_lines_v a,

3246: ) * (l_rate - b.conversion_rate )
3247: )
3248: )
3249: INTO l_reval_acct_amt_total
3250: --FROM igc_cc_acct_lines_v a,
3251: FROM igc_cc_acct_lines a,
3252: igc_cc_headers b
3253: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3254: a.cc_header_id = b.cc_header_id AND