APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGCY_SPI_INT

Line 1189: FROM igs_en_lgcy_spi_int

1185: p_deletion_flag IN BOOLEAN
1186: ) AS
1187: CURSOR c_en_spi IS
1188: SELECT *
1189: FROM igs_en_lgcy_spi_int
1190: WHERE batch_id = p_batch_id
1191: AND import_status IN ('U','R')
1192: ORDER BY person_number ASC,
1193: program_cd ASC

Line 1304: DELETE FROM igs_en_lgcy_spi_int

1300: p_int_table_id => l_en_spi_cur_rec.legacy_en_spi_int_id
1301: );
1302:
1303: -- delete the interface record
1304: DELETE FROM igs_en_lgcy_spi_int
1305: WHERE legacy_en_spi_int_id = l_en_spi_cur_rec.legacy_en_spi_int_id ;
1306: ELSE
1307: l_last_updated_by := get_last_updated_by;
1308: l_last_update_date := get_last_update_date;

Line 1314: UPDATE igs_en_lgcy_spi_int

1310: l_request_id := get_request_id;
1311: l_program_application_id := get_program_application_id;
1312: l_program_id := get_program_id;
1313: l_program_update_date := get_program_update_date;
1314: UPDATE igs_en_lgcy_spi_int
1315: SET import_status = DECODE(l_return_status,
1316: 'S','I',
1317: 'U','E',
1318: 'W','W',