eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_COST1 dependencies on PA_USAGE_COST_RATE_OVR_ALL

Line 1976: * PA_USAGE_COST_RATE_OVR_ALL is being referenced more than 3 times.

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: */
1979: l_stage := 'Getting Cost rates from Usage Overrides';
1980: print_msg(l_debug_flag,l_stage);

Line 1977: * Single-row table count exceeds 3 for PA_USAGE_COST_RATE_OVR_ALL.

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: */
1979: l_stage := 'Getting Cost rates from Usage Overrides';
1980: print_msg(l_debug_flag,l_stage);
1981: SELECT R.Rate

Line 1984: PA_Usage_Cost_Rate_Ovr_all R

1980: print_msg(l_debug_flag,l_stage);
1981: SELECT R.Rate
1982: INTO l_nlr_raw_cost_rate
1983: FROM PA_Expenditure_Types T,
1984: PA_Usage_Cost_Rate_Ovr_all R
1985: WHERE T.Expenditure_type = R.Expenditure_type
1986: AND T.Cost_Rate_Flag = 'Y'
1987: AND R.Expenditure_type = p_expenditure_type
1988: AND R.Non_Labor_Resource = p_Non_Labor_Resource