DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_LABOR_COST_MULTIPLIERS

Line 113: ,pa_labor_cost_multipliers lcm

109: l_stage := 'Getting labor cost multiplier ';
110: SELECT lcm.multiplier
111: INTO l_cost_rate_multiplier
112: FROM pa_tasks t
113: ,pa_labor_cost_multipliers lcm
114: WHERE t.task_id = p_task_id
115: AND t.labor_cost_multiplier_name = lcm.labor_cost_multiplier_name
116: AND trunc(P_exp_item_date) BETWEEN LCM.start_date_active AND
117: NVL(LCM.end_date_active,P_exp_item_date);