APPS.PA_FORECAST_COST dependencies on PA_COMPENSATION_DETAILS_ALL

Line 27: l_labor_cost_rate pa_compensation_details_all.HOURLY_COST_RATE%TYPE;

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:
31: l_no_labor_cost_rate EXCEPTION;

Line 52: -- Get the labor cost rate from pa_compensation_details_all

48:
49:
50:
51: -----------------------------------------------------------
52: -- Get the labor cost rate from pa_compensation_details_all
53: -----------------------------------------------------------
54:
55: SELECT HOURLY_COST_RATE
56: INTO l_labor_cost_rate

Line 57: FROM PA_COMPENSATION_DETAILS_ALL CD

53: -----------------------------------------------------------
54:
55: SELECT HOURLY_COST_RATE
56: INTO l_labor_cost_rate
57: FROM PA_COMPENSATION_DETAILS_ALL CD
58: WHERE CD.person_id = P_person_id
59: AND CD.org_id = P_expenditure_org_id
60: AND P_item_date BETWEEN CD.start_date_active AND NVL(CD.end_date_active,P_item_date);
61: