APPS.IGS_EN_LGCY_PRC dependencies on IGS_GR_LGCY_GRD_INT

Line 3246: FROM igs_gr_lgcy_grd_int

3242: p_deletion_flag IN BOOLEAN
3243: ) AS
3244: CURSOR c_gr_grd IS
3245: SELECT *
3246: FROM igs_gr_lgcy_grd_int
3247: WHERE batch_id = p_batch_id
3248: AND import_status IN ('U','R')
3249: FOR UPDATE NOWAIT;
3250:

Line 3362: DELETE FROM igs_gr_lgcy_grd_int

3358: p_int_table_code => g_cst_gr_grd,
3359: p_int_table_id => l_gr_grd_cur_rec.legacy_gr_int_id
3360: );
3361: -- delete the interface record
3362: DELETE FROM igs_gr_lgcy_grd_int
3363: WHERE legacy_gr_int_id = l_gr_grd_cur_rec.legacy_gr_int_id;
3364: ELSE
3365: l_last_updated_by := get_last_updated_by;
3366: l_last_update_date := get_last_update_date;

Line 3372: UPDATE igs_gr_lgcy_grd_int

3368: l_request_id := get_request_id;
3369: l_program_application_id := get_program_application_id;
3370: l_program_id := get_program_id;
3371: l_program_update_date := get_program_update_date;
3372: UPDATE igs_gr_lgcy_grd_int
3373: SET import_status = DECODE(l_return_status,
3374: 'S','I',
3375: 'U','E',
3376: 'W','W',