DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on IC_TRAN_PND

Line 30: ic_tran_pnd p, gme_batch_header hdr -- Bug 13706812 Add header table.

26: /* Bug 5620671 Added param completed ind */
27: CURSOR Cur_get_txns(v_completed_ind NUMBER) IS
28: SELECT p.*, m.new_batch_id, m.organization_id, m.new_batch_no, m.plant_code
29: FROM gme_batch_txns_mig t, gme_batch_mapping_mig m,
30: ic_tran_pnd p, gme_batch_header hdr -- Bug 13706812 Add header table.
31: WHERE t.batch_id = m.old_batch_id
32: AND p.trans_id = t.trans_id
33: AND NVL(t.migrated_ind,0) = 0
34: AND p.completed_ind = v_completed_ind