APPS.PA_COST dependencies on PA_LABOR_COST_MULTIPLIERS

Line 44: l_cost_multiplier pa_labor_cost_multipliers.multiplier%TYPE;

40: X_msg_data OUT NOCOPY VARCHAR2
41: )
42: IS
43:
44: l_cost_multiplier pa_labor_cost_multipliers.multiplier%TYPE;
45: l_labor_cost_rate pa_compensation_details_all.HOURLY_COST_RATE%TYPE;
46: l_x_raw_cost NUMBER;
47: l_x_raw_cost_rate NUMBER;
48:

Line 203: -- Get the cost multiplier from pa_labor_cost_multipliers for the given

199: END IF;
200: /***End of LCE changes ***/
201:
202: -----------------------------------------------------------------------
203: -- Get the cost multiplier from pa_labor_cost_multipliers for the given
204: -- labor cost multiplier name
205: -----------------------------------------------------------------------
206:
207:

Line 216: FROM PA_LABOR_COST_MULTIPLIERS LCM

212: BEGIN
213:
214: SELECT multiplier
215: INTO l_cost_multiplier
216: FROM PA_LABOR_COST_MULTIPLIERS LCM
217: WHERE LCM.LABOR_COST_MULTIPLIER_NAME = P_labor_Cost_Mult_Name
218: AND P_item_date BETWEEN LCM.start_date_active AND NVL(LCM.end_date_active,P_item_date);
219:
220: