APPS.IGS_EN_LGCY_PRC dependencies on IGS_RE_LGCY_SPR_INT

Line 1511: FROM igs_re_lgcy_spr_int

1507: p_deletion_flag IN BOOLEAN
1508: ) AS
1509: CURSOR c_re_sprvsr IS
1510: SELECT *
1511: FROM igs_re_lgcy_spr_int
1512: WHERE batch_id = p_batch_id
1513: AND import_status IN ('U','R')
1514: ORDER BY ca_person_number ASC,
1515: START_DT ASC

Line 1602: DELETE FROM igs_re_lgcy_spr_int

1598: p_int_table_code => g_cst_re_sprvsr,
1599: p_int_table_id => l_re_sprvsr_cur_rec.legacy_re_sprvsr_int_id
1600: );
1601: -- delete the interface record
1602: DELETE FROM igs_re_lgcy_spr_int
1603: WHERE legacy_re_sprvsr_int_id = l_re_sprvsr_cur_rec.legacy_re_sprvsr_int_id;
1604: ELSE
1605: l_last_updated_by := get_last_updated_by;
1606: l_last_update_date := get_last_update_date;

Line 1612: UPDATE igs_re_lgcy_spr_int

1608: l_request_id := get_request_id;
1609: l_program_application_id := get_program_application_id;
1610: l_program_id := get_program_id;
1611: l_program_update_date := get_program_update_date;
1612: UPDATE igs_re_lgcy_spr_int
1613: SET import_status = DECODE(l_return_status,
1614: 'S','I',
1615: 'U','E',
1616: 'W','W',