APPS.GME_BATCHSTEP_ACT_PVT dependencies on GME_BATCH_STEPS

Line 42: FROM gme_batch_steps

38:
39: CURSOR cur_get_batchstep_dtl (v_batch_id NUMBER, v_batchstep_no NUMBER)
40: IS
41: SELECT batchstep_id, step_status
42: FROM gme_batch_steps
43: WHERE batch_id = v_batch_id AND batchstep_no = v_batchstep_no;
44:
45: CURSOR cur_get_activity_id (
46: v_step_id NUMBER,

Line 208: l_step_dtl gme_batch_steps%ROWTYPE;

204: IS
205: l_api_name CONSTANT VARCHAR2 (30) := 'validate_activity_param';
206: l_batch_asqc NUMBER;
207: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
208: l_step_dtl gme_batch_steps%ROWTYPE;
209: l_dummy NUMBER;
210: l_activity_factor NUMBER;
211: l_batch_type NUMBER;
212:

Line 222: FROM gme_batch_steps

218:
219: CURSOR cur_get_step_dtl (v_step_id NUMBER)
220: IS
221: SELECT *
222: FROM gme_batch_steps
223: WHERE batchstep_id = v_step_id;
224:
225: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
226: IS

Line 234: FROM gme_batch_header b, gme_batch_steps s

230:
231: CURSOR cur_check_fpo (v_step_id NUMBER)
232: IS
233: SELECT batch_type
234: FROM gme_batch_header b, gme_batch_steps s
235: WHERE b.batch_id = s.batch_id AND batchstep_id = v_step_id;
236: BEGIN
237: IF (NVL (g_debug, 0) IN
238: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

Line 705: FROM gme_batch_steps

701: -- Define CURSORS
702: CURSOR cur_validate_step (v_step_id NUMBER)
703: IS
704: SELECT batch_id
705: FROM gme_batch_steps
706: WHERE batchstep_id = v_step_id;
707: BEGIN
708: IF (NVL (g_debug, 0) IN
709: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

Line 1060: FROM gme_batch_step_activities a, gme_batch_steps s

1056:
1057: CURSOR cur_get_dtl (v_act_id NUMBER)
1058: IS
1059: SELECT a.batch_id, a.batchstep_id, step_status, activity
1060: FROM gme_batch_step_activities a, gme_batch_steps s
1061: WHERE batchstep_activity_id = v_act_id
1062: AND a.batchstep_id = s.batchstep_id;
1063:
1064: CURSOR cur_get_step_dtl (v_step_id NUMBER)

Line 1067: FROM gme_batch_steps

1063:
1064: CURSOR cur_get_step_dtl (v_step_id NUMBER)
1065: IS
1066: SELECT *
1067: FROM gme_batch_steps
1068: WHERE batchstep_id = v_step_id;
1069:
1070: l_step_dtl gme_batch_steps%ROWTYPE;
1071:

Line 1070: l_step_dtl gme_batch_steps%ROWTYPE;

1066: SELECT *
1067: FROM gme_batch_steps
1068: WHERE batchstep_id = v_step_id;
1069:
1070: l_step_dtl gme_batch_steps%ROWTYPE;
1071:
1072: CURSOR cur_get_batch (v_batch_id NUMBER)
1073: IS
1074: SELECT *

Line 1842: FROM gme_batch_steps s,

1838: CURSOR cur_get_step_dtl (v_batchstep_act_id NUMBER)
1839: IS
1840: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1841: batchstep_activity_id, activity
1842: FROM gme_batch_steps s,
1843: gme_batch_step_activities a,
1844: gme_batch_header b
1845: WHERE batchstep_activity_id = v_batchstep_act_id
1846: AND b.batch_id = a.batch_id