APPS.GMD_SAMPLES_GRP dependencies on GME_BATCH_HEADER

Line 3389: FROM gme_batch_header

3385: l_step_no IS NOT NULL THEN
3386:
3387: -- Bug # 4619570 Allow update of batch step quality status if batch is not closed
3388: /*SELECT batch_status INTO l_batch_status -- Bug # 4619570 Need to know if batch is closed
3389: FROM gme_batch_header
3390: WHERE batch_id = l_batch_id; */
3391:
3392: -- Bug# 5440347
3393: SELECT step_status INTO l_step_status

Line 3641: FROM gme_batch_header bh

3637: --CURSOR c_item_sublot IS
3638:
3639: CURSOR c_batch IS
3640: SELECT 1
3641: FROM gme_batch_header bh
3642: WHERE bh.batch_id = p_sample.batch_id
3643: AND bh.batch_type = 0 -- Only Batches, No FPOs
3644: AND ( ( bh.batch_status IN (1,2) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) -- Bug # 4619570 Pending or WIP Batches Only
3645: OR ( bh.batch_status IN (1,2, 4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Pending or WIP Or Closed Batches Only

Line 4966: l_batch_header GME_BATCH_HEADER%ROWTYPE;

4962: ( p_batch_id IN NUMBER
4963: , x_return_status OUT NOCOPY VARCHAR2
4964: ) IS
4965:
4966: l_batch_header GME_BATCH_HEADER%ROWTYPE;
4967: l_return_status VARCHAR2(1);
4968:
4969: BEGIN
4970:

Line 6121: FROM gme_batch_header

6117:
6118: IS
6119: CURSOR Cur_vbatch IS
6120: SELECT batch_no
6121: FROM gme_batch_header
6122: WHERE batch_id = P_batch_id;
6123:
6124: CURSOR Cur_vstep IS
6125: SELECT bs.batchstep_no,