APPS.CSTPFCHK dependencies on WIP_REPETITIVE_SCHEDULES

Line 1435: FROM wip_repetitive_schedules wrs

1431: wfs.status IN (1,2) AND
1432: NVL(wfs.date_closed, l_current_start_date) >= l_current_start_date))
1433: OR (we.entity_type =2 AND EXISTS (
1434: SELECT 'X'
1435: FROM wip_repetitive_schedules wrs
1436: WHERE
1437: wrs.wip_entity_id = wppb.wip_entity_id AND
1438: wrs.line_id = wppb.line_id AND
1439: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));

Line 1505: FROM wip_repetitive_schedules wrs

1501: wdj.wip_entity_id = wprocd.wip_entity_id AND
1502: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1503: OR (we.entity_type = 2 AND EXISTS (
1504: SELECT 'X'
1505: FROM wip_repetitive_schedules wrs
1506: WHERE
1507: wrs.wip_entity_id = wprocd.wip_entity_id AND
1508: wrs.line_id = wprocd.line_id AND
1509: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));