APPS.IGC_CC_COMP_AMT_PKG dependencies on IGC_CC_COMP_AMT_PKG

Line 1: PACKAGE BODY IGC_CC_COMP_AMT_PKG AS

1: PACKAGE BODY IGC_CC_COMP_AMT_PKG AS
2: /*$Header: IGCCCBAB.pls 120.5.12000000.1 2007/08/20 12:11:21 mbremkum ship $*/
3:
4: FUNCTION COMPUTE_ACCT_BILLED_AMT_CURR(p_cc_acct_line_id NUMBER)
5: RETURN NUMBER

Line 67: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),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
69: FROM igc_cc_acct_lines ccal
70: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
71: EXCEPTION

Line 338: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id),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
340: FROM igc_cc_acct_lines ccal
341: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
342: EXCEPTION

Line 360: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT_CURR( ccal.cc_acct_line_id),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
362: FROM igc_cc_acct_lines ccal
363: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
364: EXCEPTION

Line 533: SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),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
535: FROM igc_cc_acct_lines ccal
536: WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;
537: EXCEPTION

Line 550: END IGC_CC_COMP_AMT_PKG;

546: END COMPUTE_ACCT_FUNC_BILLED_AMT;
547:
548:
549:
550: END IGC_CC_COMP_AMT_PKG;