APPS.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_ACCT_LINES

Line 3187: -- Performance Tuning, replaced view igc_cc_acct_lines_v

3183: WHERE org_id = g_org_id
3184: AND control_group_id = l_control_group_id;
3185:
3186:
3187: -- Performance Tuning, replaced view igc_cc_acct_lines_v
3188: -- with igc_cc_acct_lines
3189: -- Also replaced the following :-
3190: -- cc_acct_comp_func_amt amount
3191: CURSOR c_cc_account_lines IS

Line 3188: -- with igc_cc_acct_lines

3184: AND control_group_id = l_control_group_id;
3185:
3186:
3187: -- Performance Tuning, replaced view igc_cc_acct_lines_v
3188: -- with igc_cc_acct_lines
3189: -- Also replaced the following :-
3190: -- cc_acct_comp_func_amt amount
3191: CURSOR c_cc_account_lines IS
3192: SELECT ccal.cc_acct_line_id line_id,

Line 3196: FROM igc_cc_acct_lines ccal

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;
3199:
3200: -- Performance Tuning, replaced view igc_cc_acct_lines_v

Line 3200: -- Performance Tuning, replaced view igc_cc_acct_lines_v

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;
3199:
3200: -- Performance Tuning, replaced view igc_cc_acct_lines_v
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

Line 3201: -- with igc_cc_acct_lines

3197: WHERE ccal.cc_header_id = g_cc_header_id
3198: ORDER BY ccal.cc_acct_line_id;
3199:
3200: -- Performance Tuning, replaced view igc_cc_acct_lines_v
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,

Line 3207: FROM igc_cc_acct_lines ccal

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:
3210:
3211: CURSOR c_ccid_info (l_code_id NUMBER) IS