APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGY_SPAA_INT

Line 1362: FROM igs_en_lgy_spaa_int

1358: p_deletion_flag IN BOOLEAN
1359: ) AS
1360: CURSOR c_en_spaa IS
1361: SELECT *
1362: FROM igs_en_lgy_spaa_int
1363: WHERE batch_id = p_batch_id
1364: AND import_status IN ('U','R')
1365: ORDER BY person_number ASC,
1366: program_cd ASC

Line 1453: DELETE FROM igs_en_lgy_spaa_int

1449: p_int_table_code => g_cst_en_spaa,
1450: p_int_table_id => l_en_spaa_cur_rec.legacy_en_spaa_int_id
1451: );
1452: -- delete the interface record
1453: DELETE FROM igs_en_lgy_spaa_int
1454: WHERE legacy_en_spaa_int_id = l_en_spaa_cur_rec.legacy_en_spaa_int_id;
1455: ELSE
1456: l_last_updated_by := get_last_updated_by;
1457: l_last_update_date := get_last_update_date;

Line 1463: UPDATE igs_en_lgy_spaa_int

1459: l_request_id := get_request_id;
1460: l_program_application_id := get_program_application_id;
1461: l_program_id := get_program_id;
1462: l_program_update_date := get_program_update_date;
1463: UPDATE igs_en_lgy_spaa_int
1464: SET import_status = DECODE(l_return_status,
1465: 'S','I',
1466: 'U','E',
1467: 'W','W',