APPS.PA_FORECAST_COST dependencies on PA_LABOR_COST_MULTIPLIERS

Line 26: l_cost_multiplier pa_labor_cost_multipliers.multiplier%TYPE;

22: X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: )
24: IS
25:
26: l_cost_multiplier pa_labor_cost_multipliers.multiplier%TYPE;
27: l_labor_cost_rate pa_compensation_details_all.HOURLY_COST_RATE%TYPE;
28: l_x_raw_cost NUMBER;
29: l_x_raw_cost_rate NUMBER;
30:

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

60: AND P_item_date BETWEEN CD.start_date_active AND NVL(CD.end_date_active,P_item_date);
61:
62:
63: -----------------------------------------------------------------------
64: -- Get the cost multiplier from pa_labor_cost_multipliers for the given
65: -- labor cost multiplier name
66: -----------------------------------------------------------------------
67:
68:

Line 77: FROM PA_LABOR_COST_MULTIPLIERS LCM

73:
74:
75: SELECT multiplier
76: INTO l_cost_multiplier
77: FROM PA_LABOR_COST_MULTIPLIERS LCM
78: WHERE LCM.LABOR_COST_MULTIPLIER_NAME = P_labor_Cost_Mult_Name
79: AND P_item_date BETWEEN LCM.start_date_active AND NVL(LCM.end_date_active,P_item_date);
80:
81: