APPS.IGS_EN_LGCY_PRC dependencies on IGS_AV_LGCY_LVL_INT

Line 2417: FROM igs_av_lgcy_lvl_int

2413: p_deletion_flag IN BOOLEAN
2414: ) AS
2415: CURSOR c_av_avstdl IS
2416: SELECT *
2417: FROM igs_av_lgcy_lvl_int
2418: WHERE batch_id = p_batch_id
2419: AND import_status IN ('U','R')
2420: FOR UPDATE NOWAIT;
2421:

Line 2530: DELETE FROM igs_av_lgcy_lvl_int

2526: p_int_table_code => g_cst_av_avstdl,
2527: p_int_table_id => l_av_avstdl_cur_rec.legacy_lvl_int_id
2528: );
2529: -- delete the interface record
2530: DELETE FROM igs_av_lgcy_lvl_int
2531: WHERE legacy_lvl_int_id = l_av_avstdl_cur_rec.legacy_lvl_int_id;
2532: ELSE
2533: l_last_updated_by := get_last_updated_by;
2534: l_last_update_date := get_last_update_date;

Line 2540: UPDATE igs_av_lgcy_lvl_int

2536: l_request_id := get_request_id;
2537: l_program_application_id := get_program_application_id;
2538: l_program_id := get_program_id;
2539: l_program_update_date := get_program_update_date;
2540: UPDATE igs_av_lgcy_lvl_int
2541: SET import_status = DECODE(l_return_status,
2542: 'S','I',
2543: 'U','E',
2544: 'W','W',