APPS.GMD_SAMPLES_GRP dependencies on GMD_WIP_SPEC_VRS

Line 554: gmd_wip_spec_vrs wvr,

550: CURSOR c_wip_sampling_event IS
551: SELECT se.sampling_event_id
552: FROM gmd_sampling_events se,
553: gmd_specifications_b s,
554: gmd_wip_spec_vrs wvr,
555: gmd_event_spec_disp esd
556: WHERE s.spec_id = wvr.spec_id
557: AND wvr.spec_vr_id = esd.spec_vr_id
558: AND esd.sampling_event_id = se.sampling_event_id

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

1486: --Bug# 5440347 start
1487: --this cursor is used for single samples
1488: CURSOR cur_auto_complete_bstep IS
1489: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
1490: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs
1491: WHERE gs.SAMPLE_ID = p_update_disp_rec.sample_id
1492: AND gse.SAMPLING_EVENT_ID = gs.SAMPLING_EVENT_ID
1493: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
1494:

Line 1503: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse

1499: WHERE sampling_event_id = p_sampling_event_id;
1500:
1501: CURSOR cur_comp_auto_complete_bstep(p_sampling_event_id NUMBER) IS
1502: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
1503: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse
1504: WHERE gse.SAMPLING_EVENT_ID = p_sampling_event_id
1505: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
1506:
1507: l_auto_complete_bstep VARCHAR2(1) := NULL;

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

2301: --Bug# 5440347 start
2302: --this cursor is used for single samples
2303: CURSOR cur_auto_complete_bstep_smpl IS
2304: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2305: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,GMD_SAMPLES gs
2306: WHERE gs.SAMPLE_ID = p_sample_id
2307: AND gse.SAMPLING_EVENT_ID = gs.SAMPLING_EVENT_ID
2308: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
2309:

Line 2312: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,

2308: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;
2309:
2310: CURSOR cur_auto_complete_bstep_comp IS
2311: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2312: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,
2313: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd
2314: WHERE csd.COMPOSITE_SPEC_DISP_ID = p_composite_spec_disp_id
2315: AND esd.EVENT_SPEC_DISP_ID = csd.EVENT_SPEC_DISP_ID
2316: AND gse.SAMPLING_EVENT_ID = esd.SAMPLING_EVENT_ID