APPS.GMD_SAMPLES_GRP dependencies on GMD_WIP_SPEC_VRS

Line 620: gmd_wip_spec_vrs wvr,

616: CURSOR c_wip_sampling_event IS
617: SELECT se.sampling_event_id
618: FROM gmd_sampling_events se,
619: gmd_specifications_b s,
620: gmd_wip_spec_vrs wvr,
621: gmd_event_spec_disp esd
622: WHERE s.spec_id = wvr.spec_id
623: AND wvr.spec_vr_id = esd.spec_vr_id
624: AND esd.sampling_event_id = se.sampling_event_id

Line 1590: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs

1586: --Bug# 5440347 start
1587: --this cursor is used for single samples
1588: CURSOR cur_auto_complete_bstep IS
1589: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
1590: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs
1591: WHERE gs.SAMPLE_ID = p_update_disp_rec.sample_id
1592: AND gse.SAMPLING_EVENT_ID = gs.SAMPLING_EVENT_ID
1593: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
1594:

Line 1603: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse

1599: WHERE sampling_event_id = p_sampling_event_id;
1600:
1601: CURSOR cur_comp_auto_complete_bstep(p_sampling_event_id NUMBER) IS
1602: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
1603: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse
1604: WHERE gse.SAMPLING_EVENT_ID = p_sampling_event_id
1605: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
1606:
1607: -- -- 8252179 added cursor

Line 2534: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs

2530: --Bug# 5440347 start
2531: --this cursor is used for single samples
2532: CURSOR cur_auto_complete_bstep_smpl IS
2533: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2534: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs
2535: WHERE gs.SAMPLE_ID = p_sample_id
2536: AND gse.SAMPLING_EVENT_ID = gs.SAMPLING_EVENT_ID
2537: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
2538:

Line 2541: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,

2537: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
2538:
2539: CURSOR cur_auto_complete_bstep_comp IS
2540: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2541: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,
2542: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd
2543: WHERE csd.COMPOSITE_SPEC_DISP_ID = p_composite_spec_disp_id
2544: AND esd.EVENT_SPEC_DISP_ID = csd.EVENT_SPEC_DISP_ID
2545: AND gse.SAMPLING_EVENT_ID = esd.SAMPLING_EVENT_ID