DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_EXPENDITURE_COST_RATES_ALL

Line 411: ,PA_Expenditure_Cost_Rates_all R

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
415: AND R.org_id = p_org_id --Bug#5903720

Line 1974: /* bug fix: 3819799 changed the order of the table. Now first hit the PA_Expenditure_Cost_Rates_all instead of

1970: **/
1971:
1972: IF l_cost_rate_curr_code IS NOT NULL Then
1973:
1974: /* bug fix: 3819799 changed the order of the table. Now first hit the PA_Expenditure_Cost_Rates_all instead of
1975: * PA_Expenditure_Types. This will avoid the following issue
1976: * PA_USAGE_COST_RATE_OVR_ALL is being referenced more than 3 times.
1977: * Single-row table count exceeds 3 for PA_USAGE_COST_RATE_OVR_ALL.
1978: */