[Home] [Help]
79: (p_exp_type varchar2) Return Varchar2 IS
80:
81: Cursor cur_costrateFlag IS
82: SELECT nvl(exp.cost_rate_flag,'N')
83: FROM pa_expenditure_types exp
84: WHERE exp.expenditure_type = p_exp_type;
85:
86: l_expCostRateFlag Varchar2(10);
87:
406:
407: l_stage := 'Executing sql to get Cost rates from expenditure type ';
408: SELECT R.Cost_Rate
409: INTO l_expTypeCostRate
410: FROM PA_Expenditure_Types T
411: ,PA_Expenditure_Cost_Rates_all R
412: WHERE T.Expenditure_type = R.Expenditure_type
413: AND T.Cost_Rate_Flag = 'Y'
414: AND R.Expenditure_type = p_exp_type
1659:
1660: IF l_cost_rate_curr_code IS NOT NULL Then
1661:
1662: /* bug fix: 3819799 changed the order of the table. Now first hit the PA_Expenditure_Cost_Rates_all instead of
1663: * PA_Expenditure_Types. This will avoid the following issue
1664: * PA_USAGE_COST_RATE_OVR_ALL is being referenced more than 3 times.
1665: * Single-row table count exceeds 3 for PA_USAGE_COST_RATE_OVR_ALL.
1666: */
1667: l_stage := 'Getting Cost rates from Usage Overrides';
1667: l_stage := 'Getting Cost rates from Usage Overrides';
1668: print_msg(l_debug_flag,l_stage);
1669: SELECT R.Rate
1670: INTO l_nlr_raw_cost_rate
1671: FROM PA_Expenditure_Types T,
1672: PA_Usage_Cost_Rate_Ovr_all R
1673: WHERE T.Expenditure_type = R.Expenditure_type
1674: AND T.Cost_Rate_Flag = 'Y'
1675: AND R.Expenditure_type = p_expenditure_type