APPS.GMDRTVAL_PUB dependencies on DUAL

Line 88: FROM SYS.DUAL

84: /* Cursor Definitions. */
85: /* =================== */
86: CURSOR Cur_check_dup IS
87: SELECT 1
88: FROM SYS.DUAL
89: WHERE EXISTS (SELECT 1
90: FROM fm_rout_hdr
91: WHERE routing_no = prouting_no
92: AND routing_vers = prouting_vers);

Line 143: FROM SYS.DUAL

139: /* Cursor Definitions. */
140: /* =================== */
141: CURSOR Cur_routing_class IS
142: SELECT 1
143: FROM SYS.DUAL
144: WHERE EXISTS (SELECT 1
145: FROM fm_rout_cls
146: WHERE routing_class = prouting_class
147: AND delete_mark = 0);

Line 198: FROM SYS.DUAL

194: /* Cursor Definitions. */
195: /* =================== */
196: CURSOR Cur_dup_routingstep IS
197: SELECT 1
198: FROM SYS.DUAL
199: WHERE EXISTS (SELECT 1
200: FROM fm_rout_dtl
201: WHERE routing_id = prouting_id
202: AND routingstep_no = proutingstep_no);

Line 942: FROM SYS.DUAL

938: X_return BOOLEAN := FALSE;
939: /* Define cursor */
940: CURSOR Cur_check_step(v_routingstep_id NUMBER) IS
941: SELECT 1
942: FROM SYS.DUAL
943: WHERE EXISTS (SELECT 1
944: FROM gmd_recipe_routing_steps
945: WHERE routingstep_id = v_routingstep_id);
946:

Line 1044: FROM SYS.DUAL

1040: /* Cursor Definitions. */
1041: /* =================== */
1042: CURSOR Cur_ownerorgn_code IS
1043: SELECT 1
1044: FROM SYS.DUAL
1045: WHERE EXISTS (SELECT 1
1046: FROM sy_orgn_usr
1047: WHERE user_id = powner_id
1048: AND orgn_code = powner_orgn);

Line 1094: FROM SYS.DUAL

1090: /* Cursor Definitions. */
1091: /* =================== */
1092: CURSOR Cur_step_no IS
1093: SELECT 1
1094: FROM SYS.DUAL
1095: WHERE EXISTS (SELECT 1
1096: FROM fm_rout_dep
1097: WHERE routing_id = prouting_id
1098: AND routingstep_no = proutingStep_no