[Home] [Help]
874: SELECT 'Y'
875: INTO x_exists
876: FROM dual
877: WHERE EXISTS (SELECT 1
878: from WIP_REQUIREMENT_OPERATIONS
879: where wip_entity_id = p_wip_entity_id
880: and organization_id = p_organization_id
881: and operation_seq_num = p_operation_seq_num
882: and NVL(repetitive_schedule_id, -1) = NVL(p_rep_schedule_id, -1));