680: SELECT 1 INTO l_rout_exists
681: FROM dual
682: WHERE exists(
683: SELECT routing_sequence_id
684: FROM bom_operational_routings
685: WHERE assembly_item_id = g_DiscreteJob_rec.primary_item_id
686: AND organization_id = g_DiscreteJob_rec.organization_id);
687:
688: IF (l_rout_exists = 0) THEN
721: SELECT 1 INTO l_rout_exists
722: FROM dual
723: WHERE exists(
724: SELECT routing_sequence_id
725: FROM bom_operational_routings
726: WHERE assembly_item_id = g_DiscreteJob_rec.primary_item_id
727: AND organization_id = g_DiscreteJob_rec.organization_id);
728:
729: IF (l_rout_exists = 0) THEN