32: /*========================================================+
33: | 21-MAY-03 Burdening Enhancements. |
34: | Added Cost Base join to pa_ind_compiled_sets |
35: +========================================================*/
36: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
37: l_projfunc_currency_code)),
38: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
39: l_denom_currency_code)),
40: SUM(PA_CURRENCY.round_currency_amt(direct_cost_acct * icpm.compiled_multiplier)),
34: | Added Cost Base join to pa_ind_compiled_sets |
35: +========================================================*/
36: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
37: l_projfunc_currency_code)),
38: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
39: l_denom_currency_code)),
40: SUM(PA_CURRENCY.round_currency_amt(direct_cost_acct * icpm.compiled_multiplier)),
41: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
42: l_project_currency_code))
36: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
37: l_projfunc_currency_code)),
38: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
39: l_denom_currency_code)),
40: SUM(PA_CURRENCY.round_currency_amt(direct_cost_acct * icpm.compiled_multiplier)),
41: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
42: l_project_currency_code))
43: into indirect_cost_sum,
44: indirect_cost_denom_sum,
37: l_projfunc_currency_code)),
38: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
39: l_denom_currency_code)),
40: SUM(PA_CURRENCY.round_currency_amt(direct_cost_acct * icpm.compiled_multiplier)),
41: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
42: l_project_currency_code))
43: into indirect_cost_sum,
44: indirect_cost_denom_sum,
45: indirect_cost_acct_sum,
355: stage := 400;
356: return;
357: END IF;
358:
359: /*indirect_cost := PA_CURRENCY.ROUND_CURRENCY_AMT(direct_cost*compiled_multiplier);Bug# 2110452*/
360:
361: EXCEPTION
362:
363: WHEN OTHERS THEN