APPS.IGS_EN_LGCY_PRC dependencies on IGS_RE_LGCY_THE_INT

Line 1660: FROM igs_re_lgcy_the_int

1656: p_deletion_flag IN BOOLEAN
1657: ) AS
1658: CURSOR c_re_the IS
1659: SELECT *
1660: FROM igs_re_lgcy_the_int
1661: WHERE batch_id = p_batch_id
1662: AND import_status IN ('U','R')
1663: ORDER BY person_number ASC,
1664: program_cd ASC

Line 1759: DELETE FROM igs_re_lgcy_the_int

1755: p_int_table_code => g_cst_re_the,
1756: p_int_table_id => l_re_the_cur_rec.legacy_re_the_int_id
1757: );
1758: -- delete the interface record
1759: DELETE FROM igs_re_lgcy_the_int
1760: WHERE legacy_re_the_int_id = l_re_the_cur_rec.legacy_re_the_int_id ;
1761: ELSE
1762: l_last_updated_by := get_last_updated_by;
1763: l_last_update_date := get_last_update_date;

Line 1769: UPDATE igs_re_lgcy_the_int

1765: l_request_id := get_request_id;
1766: l_program_application_id := get_program_application_id;
1767: l_program_id := get_program_id;
1768: l_program_update_date := get_program_update_date;
1769: UPDATE igs_re_lgcy_the_int
1770: SET import_status = DECODE(l_return_status,
1771: 'S','I',
1772: 'U','E',
1773: 'W','W',