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 1664: * PA_USAGE_COST_RATE_OVR_ALL is being referenced more than 3 times.

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';
1668: print_msg(l_debug_flag,l_stage);

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

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';
1668: print_msg(l_debug_flag,l_stage);
1669: SELECT R.Rate

Line 1672: PA_Usage_Cost_Rate_Ovr_all R

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
1676: AND R.Non_Labor_Resource = p_Non_Labor_Resource