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 189: -- Get the cost multiplier from pa_labor_cost_multipliers for the given

185: END IF;
186: /***End of LCE changes ***/
187:
188: -----------------------------------------------------------------------
189: -- Get the cost multiplier from pa_labor_cost_multipliers for the given
190: -- labor cost multiplier name
191: -----------------------------------------------------------------------
192:
193:

Line 201: FROM PA_LABOR_COST_MULTIPLIERS LCM

197: BEGIN
198:
199: SELECT multiplier
200: INTO l_cost_multiplier
201: FROM PA_LABOR_COST_MULTIPLIERS LCM
202: WHERE LCM.LABOR_COST_MULTIPLIER_NAME = P_labor_Cost_Mult_Name
203: AND P_item_date BETWEEN LCM.start_date_active AND NVL(LCM.end_date_active,P_item_date);
204:
205: