DBA Data[Home] [Help]

APPS.PA_DATE_OVERLAP_CHECKS dependencies on PA_LABOR_COST_MULTIPLIERS

Line 24: from pa_labor_cost_multipliers a,

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)

Line 25: pa_labor_cost_multipliers b

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