DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_COMP_AMT_PKG

Line 3194: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,

3190: -- cc_acct_comp_func_amt amount
3191: CURSOR c_cc_account_lines IS
3192: SELECT ccal.cc_acct_line_id line_id,
3193: ccal.cc_charge_code_combination_id ccid,
3194: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
3195: NVL(ccal.cc_acct_entered_amt,0)) amount
3196: FROM igc_cc_acct_lines ccal
3197: WHERE ccal.cc_header_id = g_cc_header_id
3198: ORDER BY ccal.cc_acct_line_id;

Line 3205: SELECT SUM(IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,

3201: -- with igc_cc_acct_lines
3202: -- Also replaced the following :-
3203: -- SELECT SUM(cc_acct_comp_func_amt)
3204: CURSOR c_total_amount IS
3205: SELECT SUM(IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
3206: NVL(ccal.cc_acct_entered_amt,0)))
3207: FROM igc_cc_acct_lines ccal
3208: WHERE ccal.cc_header_id = g_cc_header_id;
3209: