APPS.CSTPFCHK dependencies on WIP_REPETITIVE_SCHEDULES

Line 1430: FROM wip_repetitive_schedules wrs

1426: wfs.status IN (1,2) AND
1427: NVL(wfs.date_closed, l_current_start_date) >= l_current_start_date))
1428: OR (we.entity_type =2 AND EXISTS (
1429: SELECT 'X'
1430: FROM wip_repetitive_schedules wrs
1431: WHERE
1432: wrs.wip_entity_id = wppb.wip_entity_id AND
1433: wrs.line_id = wppb.line_id AND
1434: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));

Line 1500: FROM wip_repetitive_schedules wrs

1496: wdj.wip_entity_id = wprocd.wip_entity_id AND
1497: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1498: OR (we.entity_type = 2 AND EXISTS (
1499: SELECT 'X'
1500: FROM wip_repetitive_schedules wrs
1501: WHERE
1502: wrs.wip_entity_id = wprocd.wip_entity_id AND
1503: wrs.line_id = wprocd.line_id AND
1504: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));