20:
21:
22: cursor c1 is
23: select a.labor_cost_multiplier_name
24: from pa_labor_cost_multipliers a,
25: pa_labor_cost_multipliers b
26: where a.labor_cost_multiplier_name = b.labor_cost_multiplier_name
27: and (a.start_date_active between b.start_date_active
28: and nvl(b.end_date_active, a.start_date_active + 1)
21:
22: cursor c1 is
23: select a.labor_cost_multiplier_name
24: from pa_labor_cost_multipliers a,
25: pa_labor_cost_multipliers b
26: where a.labor_cost_multiplier_name = b.labor_cost_multiplier_name
27: and (a.start_date_active between b.start_date_active
28: and nvl(b.end_date_active, a.start_date_active + 1)
29: or a.end_date_active between b.start_date_active