APPS.IGS_EN_LGCY_PRC dependencies on IGS_AS_LGCY_STC_INT

Line 3419: FROM igs_as_lgcy_stc_int

3415: p_deletion_flag IN BOOLEAN
3416: ) AS
3417: CURSOR c_as_trncmt IS
3418: SELECT *
3419: FROM igs_as_lgcy_stc_int
3420: WHERE batch_id = p_batch_id
3421: AND import_status IN ('U','R')
3422: FOR UPDATE NOWAIT;
3423:

Line 3509: DELETE FROM igs_as_lgcy_stc_int

3505: p_int_table_code => g_cst_as_trncmt,
3506: p_int_table_id => l_as_trncmt_cur_rec.legacy_cmts_int_id
3507: );
3508: -- delete the interface record
3509: DELETE FROM igs_as_lgcy_stc_int
3510: WHERE legacy_cmts_int_id = l_as_trncmt_cur_rec.legacy_cmts_int_id;
3511: ELSE
3512: l_last_updated_by := get_last_updated_by;
3513: l_last_update_date := get_last_update_date;

Line 3519: UPDATE igs_as_lgcy_stc_int

3515: l_request_id := get_request_id;
3516: l_program_application_id := get_program_application_id;
3517: l_program_id := get_program_id;
3518: l_program_update_date := get_program_update_date;
3519: UPDATE igs_as_lgcy_stc_int
3520: SET import_status = DECODE(l_return_status,
3521: 'S','I',
3522: 'U','E',
3523: 'W','W',