APPS.GMD_ROUTING_STEPS_PVT dependencies on DUAL

Line 50: FROM sys.dual;

46: /*define cursor */
47: /* get routing step id sequence */
48: CURSOR Get_routingstep_id_seq IS
49: SELECT gem5_routingstep_id_s.NEXTVAL
50: FROM sys.dual;
51:
52: /* Exception section */
53: routing_step_creation_failure EXCEPTION;
54: invalid_version EXCEPTION;

Line 742: FROM SYS.DUAL

738:
739:
740: CURSOR Cur_check_step IS
741: SELECT 1
742: FROM SYS.DUAL
743: WHERE EXISTS (SELECT 1
744: FROM gmd_recipe_routing_steps
745: WHERE routingstep_id = p_routingstep_id);
746:

Line 749: FROM sys.dual

745: WHERE routingstep_id = p_routingstep_id);
746:
747: CURSOR Cur_check_step2 IS
748: SELECT 1
749: FROM sys.dual
750: WHERE EXISTS (SELECT 1
751: FROM gmd_recipe_step_materials
752: WHERE routingstep_id = p_routingstep_id);
753:

Line 756: FROM sys.dual

752: WHERE routingstep_id = p_routingstep_id);
753:
754: CURSOR Cur_check_orgn_act IS
755: SELECT 1
756: FROM sys.dual
757: WHERE EXISTS (SELECT 1
758: FROM gmd_recipe_orgn_activities
759: WHERE routingstep_id = p_routingstep_id);
760:

Line 763: FROM sys.dual

759: WHERE routingstep_id = p_routingstep_id);
760:
761: CURSOR Cur_check_orgn_res IS
762: SELECT 1
763: FROM sys.dual
764: WHERE EXISTS (SELECT 1
765: FROM gmd_recipe_orgn_resources
766: WHERE routingstep_id = p_routingstep_id);
767: