APPS.GMD_SAMPLES_GRP dependencies on GME_BATCH_HEADER

Line 2805: FROM gme_batch_header

2801: l_step_no IS NOT NULL THEN
2802:
2803: -- Bug # 4619570 Allow update of batch step quality status if batch is not closed
2804: /*SELECT batch_status INTO l_batch_status -- Bug # 4619570 Need to know if batch is closed
2805: FROM gme_batch_header
2806: WHERE batch_id = l_batch_id; */
2807:
2808: -- Bug# 5440347
2809: SELECT step_status INTO l_step_status

Line 3046: FROM gme_batch_header bh

3042: --CURSOR c_item_sublot IS
3043:
3044: CURSOR c_batch IS
3045: SELECT 1
3046: FROM gme_batch_header bh
3047: WHERE bh.batch_id = p_sample.batch_id
3048: AND bh.batch_type = 0 -- Only Batches, No FPOs
3049: 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
3050: 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 4321: l_batch_header GME_BATCH_HEADER%ROWTYPE;

4317: ( p_batch_id IN NUMBER
4318: , x_return_status OUT NOCOPY VARCHAR2
4319: ) IS
4320:
4321: l_batch_header GME_BATCH_HEADER%ROWTYPE;
4322: l_return_status VARCHAR2(1);
4323:
4324: BEGIN
4325:

Line 5453: FROM gme_batch_header

5449:
5450: IS
5451: CURSOR Cur_vbatch IS
5452: SELECT batch_no
5453: FROM gme_batch_header
5454: WHERE batch_id = P_batch_id;
5455:
5456: CURSOR Cur_vstep IS
5457: SELECT bs.batchstep_no,