APPS.OPI_EDW_JOB_RSRC_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 130: FROM wip_repetitive_schedules

126: /* fix for bug 2839182 */
127: IF l_cmpl_date IS NULL THEN
128: SELECT Decode( status_type,12, date_closed, last_update_date)
129: INTO l_cmpl_date
130: FROM wip_repetitive_schedules
131: WHERE status_type IN (4,5,7,12)
132: AND repetitive_schedule_id = p_repetitive_schedule_id;
133: END IF;
134: