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_COMP_AMT_PKG dependencies on IGC_CC_ACCT_LINES

Line 12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

8: l_cc_num igc_cc_headers.cc_num%TYPE;
9: l_cc_type igc_cc_headers.cc_type%TYPE;
10: l_org_id igc_cc_headers.org_id%TYPE;
11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
13: BEGIN
14:
15: SELECT cc_acct_line_num, cc_header_id
16: INTO l_cc_acct_line_num, l_cc_header_id

Line 17: FROM igc_cc_acct_lines

13: BEGIN
14:
15: SELECT cc_acct_line_num, cc_header_id
16: INTO l_cc_acct_line_num, l_cc_header_id
17: FROM igc_cc_acct_lines
18: WHERE cc_acct_line_id = p_cc_acct_line_id;
19:
20: SELECT cc_num, org_id, cc_type
21: INTO l_cc_num, l_org_id, l_cc_type

Line 64: FROM igc_cc_acct_lines

60: -- with the one below.
61: /*
62: SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
63: INTO l_func_billed_amount
64: FROM igc_cc_acct_lines
65: WHERE parent_acct_line_id = p_cc_acct_line_id;
66: */
67: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
68: INTO l_func_billed_amount

Line 69: FROM igc_cc_acct_lines ccal

65: WHERE parent_acct_line_id = p_cc_acct_line_id;
66: */
67: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
68: INTO l_func_billed_amount
69: FROM igc_cc_acct_lines ccal
70: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
71: EXCEPTION
72: WHEN NO_DATA_FOUND
73: THEN

Line 92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

88: l_cc_num igc_cc_headers.cc_num%TYPE;
89: l_cc_type igc_cc_headers.cc_type%TYPE;
90: l_org_id igc_cc_headers.org_id%TYPE;
91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
93: BEGIN
94:
95: SELECT cc_acct_line_num, cc_header_id
96: INTO l_cc_acct_line_num, l_cc_header_id

Line 97: FROM igc_cc_acct_lines

93: BEGIN
94:
95: SELECT cc_acct_line_num, cc_header_id
96: INTO l_cc_acct_line_num, l_cc_header_id
97: FROM igc_cc_acct_lines
98: WHERE cc_acct_line_id = p_cc_acct_line_id;
99:
100: SELECT cc_num, org_id, cc_type
101: INTO l_cc_num, l_org_id, l_cc_type

Line 165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

161: l_cc_num igc_cc_headers.cc_num%TYPE;
162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;
168: l_func_currency_code igc_cc_headers.currency_code%TYPE;
169: BEGIN

Line 173: FROM igc_cc_acct_lines

169: BEGIN
170:
171: SELECT cc_acct_line_num, cc_header_id
172: INTO l_cc_acct_line_num, l_cc_header_id
173: FROM igc_cc_acct_lines
174: WHERE cc_acct_line_id = p_cc_acct_line_id;
175:
176: SELECT cc_num, org_id, cc_type, set_of_books_id, currency_code
177: INTO l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code

Line 270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

266: l_cc_num igc_cc_headers.cc_num%TYPE;
267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;
273: l_func_currency_code igc_cc_headers.currency_code%TYPE;
274: BEGIN

Line 278: FROM igc_cc_acct_lines

274: BEGIN
275:
276: SELECT cc_acct_line_num, cc_header_id
277: INTO l_cc_acct_line_num, l_cc_header_id
278: FROM igc_cc_acct_lines
279: WHERE cc_acct_line_id = p_cc_acct_line_id;
280:
281: SELECT cc_num, org_id, cc_type, set_of_books_id, currency_code
282: INTO l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code

Line 335: FROM igc_cc_acct_lines_v

331: -- sql with a direct select from the table
332: /*
333: SELECT NVL(SUM(NVL(cc_acct_billed_amt,0)),0)
334: INTO l_billed_amount
335: FROM igc_cc_acct_lines_v
336: WHERE parent_acct_line_id = p_cc_acct_line_id;
337: */
338: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
339: INTO l_billed_amount

Line 340: FROM igc_cc_acct_lines ccal

336: WHERE parent_acct_line_id = p_cc_acct_line_id;
337: */
338: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
339: INTO l_billed_amount
340: FROM igc_cc_acct_lines ccal
341: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
342: EXCEPTION
343: WHEN NO_DATA_FOUND
344: THEN

Line 357: FROM igc_cc_acct_lines_v

353: -- sql with the one below.
354: /*
355: SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
356: INTO l_billed_amount
357: FROM igc_cc_acct_lines_v
358: WHERE parent_acct_line_id = p_cc_acct_line_id;
359: */
360: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT_CURR( ccal.cc_acct_line_id),0)),0)
361: INTO l_billed_amount

Line 362: FROM igc_cc_acct_lines ccal

358: WHERE parent_acct_line_id = p_cc_acct_line_id;
359: */
360: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT_CURR( ccal.cc_acct_line_id),0)),0)
361: INTO l_billed_amount
362: FROM igc_cc_acct_lines ccal
363: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
364: EXCEPTION
365: WHEN NO_DATA_FOUND
366: THEN

Line 381: l_cc_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

377: FUNCTION COMPUTE_FUNCTIONAL_AMT ( p_cc_header_id NUMBER, p_cc_func_amt NUMBER)
378: RETURN NUMBER
379: IS
380: l_cc_conversion_rate igc_cc_headers.conversion_rate%TYPE;
381: l_cc_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
382: BEGIN
383: BEGIN
384: SELECT cc.conversion_rate
385: INTO l_cc_conversion_rate

Line 409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

405: l_cc_num igc_cc_headers.cc_num%TYPE;
406: l_cc_type igc_cc_headers.cc_type%TYPE;
407: l_org_id igc_cc_headers.org_id%TYPE;
408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
410: BEGIN
411:
412: SELECT cc_acct_line_num, cc_header_id
413: INTO l_cc_acct_line_num, l_cc_header_id

Line 414: FROM igc_cc_acct_lines

410: BEGIN
411:
412: SELECT cc_acct_line_num, cc_header_id
413: INTO l_cc_acct_line_num, l_cc_header_id
414: FROM igc_cc_acct_lines
415: WHERE cc_acct_line_id = p_cc_acct_line_id;
416:
417: SELECT cc_num, org_id, cc_type
418: INTO l_cc_num, l_org_id, l_cc_type

Line 479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

475: l_cc_num igc_cc_headers.cc_num%TYPE;
476: l_cc_type igc_cc_headers.cc_type%TYPE;
477: l_org_id igc_cc_headers.org_id%TYPE;
478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
480: BEGIN
481:
482: SELECT cc_acct_line_num, cc_header_id
483: INTO l_cc_acct_line_num, l_cc_header_id

Line 484: FROM igc_cc_acct_lines

480: BEGIN
481:
482: SELECT cc_acct_line_num, cc_header_id
483: INTO l_cc_acct_line_num, l_cc_header_id
484: FROM igc_cc_acct_lines
485: WHERE cc_acct_line_id = p_cc_acct_line_id;
486:
487: SELECT cc_num, org_id, cc_type
488: INTO l_cc_num, l_org_id, l_cc_type

Line 530: FROM igc_cc_acct_lines

526: -- with the one below.
527: /*
528: SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
529: INTO l_func_billed_amount
530: FROM igc_cc_acct_lines
531: WHERE parent_acct_line_id = p_cc_acct_line_id;
532: */
533: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
534: INTO l_func_billed_amount

Line 535: FROM igc_cc_acct_lines ccal

531: WHERE parent_acct_line_id = p_cc_acct_line_id;
532: */
533: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
534: INTO l_func_billed_amount
535: FROM igc_cc_acct_lines ccal
536: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
537: EXCEPTION
538: WHEN NO_DATA_FOUND
539: THEN