APPS.GMD_QM_VALIDATE_FIX dependencies on DUAL

Line 6: select GMD_QC_SPEC_HDR_ID_S.nextval from dual;

2: /* $Header: GMDQVADB.pls 120.0.12020000.2 2012/07/17 10:13:54 mtou ship $ */
3:
4: PROCEDURE POPULATE_SPEC_HEADER IS
5: cursor get_nextval is
6: select GMD_QC_SPEC_HDR_ID_S.nextval from dual;
7:
8: cursor get_spec IS
9: select *
10: from qc_spec_mst

Line 184: SELECT sysdate from dual;

180: |
181: *=======================================================================*/
182:
183: CURSOR c_sysdate IS
184: SELECT sysdate from dual;
185:
186: CURSOR c_22hrs IS
187: SELECT sysdate - 80000 / 86400 from dual;
188:

Line 187: SELECT sysdate - 80000 / 86400 from dual;

183: CURSOR c_sysdate IS
184: SELECT sysdate from dual;
185:
186: CURSOR c_22hrs IS
187: SELECT sysdate - 80000 / 86400 from dual;
188:
189: -- Bug 3542894
190: CURSOR c_spec_less_from_date IS
191: SELECT a.spec_hdr_id,