APPS.GMD_QC_MIGRATE_TO_1151J dependencies on DUAL

Line 2142: SELECT sysdate FROM DUAL;

2138: -- gmd_qc_spec_mst_gtmp
2139:
2140: /* Get SYSDATE */
2141: CURSOR c_get_sysdate IS
2142: SELECT sysdate FROM DUAL;
2143:
2144: /* Get the ids of the spec header groupings that have not been migrated */
2145: CURSOR c_get_spec_header IS
2146: SELECT DISTINCT spec_hdr_id, item_id, orgn_code

Line 2215: FROM SYS.DUAL;

2211:
2212: /* Get the next spec id */
2213: CURSOR c_get_spec_id IS
2214: SELECT gmd_qc_spec_id_s.nextval
2215: FROM SYS.DUAL;
2216:
2217: /* Get the next spec validity rule id */
2218: CURSOR c_get_spec_vr_id IS
2219: SELECT gmd_qc_spec_vr_id_s.nextval

Line 2220: FROM SYS.DUAL;

2216:
2217: /* Get the next spec validity rule id */
2218: CURSOR c_get_spec_vr_id IS
2219: SELECT gmd_qc_spec_vr_id_s.nextval
2220: FROM SYS.DUAL;
2221:
2222: /* Bug 3934121; Removed CURSOR c_chk_for_dup_tests */
2223: /* Bug 3934121; Removed CURSOR c_get_dup_tests */
2224:

Line 3825: FROM SYS.DUAL;

3821:
3822: /* Get the next spec validity rule id */
3823: CURSOR c_get_sampling_event_id IS
3824: SELECT gmd_qc_sampling_event_id_s.nextval
3825: FROM SYS.DUAL;
3826:
3827: /* Get the next event spec diposition id */
3828: CURSOR c_get_event_spec_disp_id IS
3829: SELECT gmd_qc_event_spec_disp_id_s.nextval

Line 3830: FROM SYS.DUAL;

3826:
3827: /* Get the next event spec diposition id */
3828: CURSOR c_get_event_spec_disp_id IS
3829: SELECT gmd_qc_event_spec_disp_id_s.nextval
3830: FROM SYS.DUAL;
3831:
3832: /* Select sample data that has not been migrated */
3833: CURSOR c_get_samples IS
3834: SELECT sample_id,

Line 5897: select sysdate into l_date from dual ;

5893: -- 29-Apr-2004 B.Stone Bug 3601780; Changed sample disposition to
5894: -- Complete for samples with results for all
5895: -- tests and all tests are evaluated.
5896:
5897: select sysdate into l_date from dual ;
5898:
5899: GMA_MIGRATION.gma_insert_message (
5900: p_run_id => p_migration_id,
5901: p_table_name => 'Create_Sample_Results',