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 709: FROM gme_batch_steps

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

Line 1067: FROM gme_batch_step_activities a, gme_batch_steps s

1063:
1064: CURSOR cur_get_dtl (v_act_id NUMBER)
1065: IS
1066: SELECT a.batch_id, a.batchstep_id, step_status, activity
1067: FROM gme_batch_step_activities a, gme_batch_steps s
1068: WHERE batchstep_activity_id = v_act_id
1069: AND a.batchstep_id = s.batchstep_id;
1070:
1071: CURSOR cur_get_step_dtl (v_step_id NUMBER)

Line 1074: FROM gme_batch_steps

1070:
1071: CURSOR cur_get_step_dtl (v_step_id NUMBER)
1072: IS
1073: SELECT *
1074: FROM gme_batch_steps
1075: WHERE batchstep_id = v_step_id;
1076:
1077: l_step_dtl gme_batch_steps%ROWTYPE;
1078:

Line 1077: l_step_dtl gme_batch_steps%ROWTYPE;

1073: SELECT *
1074: FROM gme_batch_steps
1075: WHERE batchstep_id = v_step_id;
1076:
1077: l_step_dtl gme_batch_steps%ROWTYPE;
1078:
1079: CURSOR cur_get_batch (v_batch_id NUMBER)
1080: IS
1081: SELECT *

Line 1849: FROM gme_batch_steps s,

1845: CURSOR cur_get_step_dtl (v_batchstep_act_id NUMBER)
1846: IS
1847: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1848: batchstep_activity_id, activity
1849: FROM gme_batch_steps s,
1850: gme_batch_step_activities a,
1851: gme_batch_header b
1852: WHERE batchstep_activity_id = v_batchstep_act_id
1853: AND b.batch_id = a.batch_id