APPS.GMDOPVAL_PUB dependencies on DUAL

Line 34: FROM SYS.DUAL

30: /* Cursor Definitions.
31: =================== */
32: CURSOR Cur_check_dup IS
33: SELECT 1
34: FROM SYS.DUAL
35: WHERE EXISTS (SELECT 1
36: FROM gmd_operations
37: WHERE oprn_no = poprn_no
38: AND oprn_vers = poprn_vers);

Line 83: FROM SYS.DUAL

79: /* Cursor Definitions.
80: =================== */
81: CURSOR Cur_oprn_class IS
82: SELECT 1
83: FROM SYS.DUAL
84: WHERE EXISTS (SELECT 1
85: FROM fm_oprn_cls
86: WHERE oprn_class = poprn_class
87: AND delete_mark = 0);

Line 132: FROM SYS.DUAL

128: ==================================================================== */
129: FUNCTION check_activity(pactivity IN VARCHAR2, pcalledby_form IN VARCHAR2 DEFAULT 'F') RETURN NUMBER IS
130: CURSOR Cur_check_actv IS
131: SELECT 1
132: FROM SYS.DUAL
133: WHERE EXISTS (SELECT 1
134: FROM fm_actv_mst
135: WHERE activity = pactivity
136: AND delete_mark = 0);

Line 184: FROM SYS.DUAL

180: ==================================================================== */
181: FUNCTION check_resource(presource IN VARCHAR2, pcalledby_form IN VARCHAR2 DEFAULT 'F') RETURN NUMBER IS
182: CURSOR Cur_check_rsrc IS
183: SELECT 1
184: FROM SYS.DUAL
185: WHERE EXISTS (SELECT 1
186: FROM cr_rsrc_mst
187: WHERE resources = presource
188: AND delete_mark = 0);

Line 238: FROM SYS.DUAL

234: /* Cursor Definitions.
235: =================== */
236: CURSOR Cur_cost_cmpnt_cls IS
237: SELECT 1
238: FROM SYS.DUAL
239: WHERE EXISTS (SELECT 1
240: FROM cm_cmpt_mst
241: WHERE cost_cmpntcls_code = pcost_cmpntcls_code
242: AND delete_mark = 0);

Line 289: FROM SYS.DUAL

285: /* Cursor Definitions.
286: =================== */
287: CURSOR Cur_analysis_code IS
288: SELECT 1
289: FROM SYS.DUAL
290: WHERE EXISTS (SELECT 1
291: FROM cm_alys_mst
292: WHERE cost_analysis_code = pcost_analysis_code
293: AND delete_mark=0);