APPS.IGS_EN_GEN_018 dependencies on IGS_EN_BAT_SUA_INTS

Line 526: FROM igs_en_bat_sua_ints

522: AND cal.sequence_number=ttol.teach_ci_sequence_number);
523:
524: CURSOR c_batch_desc (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
525: SELECT batch_desc
526: FROM igs_en_bat_sua_ints
527: WHERE batch_id=cp_batch_id;
528:
529: CURSOR c_delete_bat (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
530: SELECT '1'

Line 1218: DELETE FROM igs_en_bat_sua_ints WHERE batch_id=p_batch_id;

1214: DELETE FROM igs_en_blk_sua_ints WHERE batch_id=p_batch_id AND status_flag='S';
1215: OPEN c_delete_bat (p_batch_id);
1216: FETCH c_delete_bat INTO l_dummy;
1217: IF c_delete_bat%NOTFOUND THEN
1218: DELETE FROM igs_en_bat_sua_ints WHERE batch_id=p_batch_id;
1219: END IF;
1220: CLOSE c_delete_bat ;
1221: END IF;
1222: