APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEPS_MIG

Line 79: FROM gme_batch_steps_mig

75: FROM ic_tran_pnd
76: WHERE trans_id = v_trans_id;
77: CURSOR Cur_get_steps(v_batch_id NUMBER) IS
78: SELECT *
79: FROM gme_batch_steps_mig
80: WHERE batch_id = v_batch_id
81: ORDER BY batchstep_no;
82: CURSOR Cur_get_activities(v_batchstep_id NUMBER) IS
83: SELECT *

Line 1100: FROM gme_batch_steps_mig m, gme_batch_steps s

1096: FUNCTION get_new_step_id(p_old_step_id IN NUMBER,
1097: p_new_batch_id IN NUMBER) RETURN NUMBER IS
1098: CURSOR Cur_get_step IS
1099: SELECT s.batchstep_id
1100: FROM gme_batch_steps_mig m, gme_batch_steps s
1101: WHERE m.batchstep_id = p_old_step_id
1102: AND s.batch_id = p_new_batch_id
1103: AND s.batchstep_no = m.batchstep_no;
1104: l_batchstep_id NUMBER;

Line 1505: FROM gme_batch_steps_mig m, gme_batch_steps s

1501: ORDER BY m.organization_id, m.new_batch_no;
1502: CURSOR Cur_get_steps(v_old_batch_id NUMBER, v_new_batch_id NUMBER) IS
1503: SELECT s.*, m.step_status old_step_status, m.actual_start_date old_actual_start_date,
1504: m.actual_cmplt_date old_actual_cmplt_date
1505: FROM gme_batch_steps_mig m, gme_batch_steps s
1506: WHERE m.batch_id = v_old_batch_id
1507: AND s.batch_id = v_new_batch_id
1508: AND m.step_status > gme_common_pvt.g_step_pending
1509: AND s.batchstep_no = m.batchstep_no

Line 3318: FROM gme_batch_steps_mig m, gme_batch_steps s, gme_batch_mapping_mig bm

3314:
3315: PROCEDURE close_steps IS
3316: CURSOR Cur_get_steps IS
3317: SELECT s.batchstep_id, m.step_close_date, bm.new_batch_no, s.batchstep_no, bm.plant_code, bm.old_batch_id
3318: FROM gme_batch_steps_mig m, gme_batch_steps s, gme_batch_mapping_mig bm
3319: WHERE m.step_status = gme_common_pvt.g_step_closed
3320: AND bm.old_batch_id = m.batch_id
3321: AND s.batch_id = bm.new_batch_id
3322: AND s.batchstep_no = m.batchstep_no