APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGCY_SUA_INT

Line 1824: FROM igs_en_lgcy_sua_int suai,

1820: -- creation fails. Term Based Fee Calc build. Bug# 2829263.
1821: -----------------------------------------------------------------------------------------------------
1822: CURSOR c_en_sua IS
1823: SELECT suai.*
1824: FROM igs_en_lgcy_sua_int suai,
1825: igs_ca_inst ci
1826: WHERE batch_id = p_batch_id
1827: AND import_status IN ('U','R')
1828: AND suai.teach_calendar_alternate_code = ci.alternate_code(+)

Line 1983: DELETE FROM igs_en_lgcy_sua_int

1979: p_int_table_code => g_cst_en_sua,
1980: p_int_table_id => l_en_sua_cur_rec.legacy_en_sua_int_id
1981: );
1982: -- delete the interface record
1983: DELETE FROM igs_en_lgcy_sua_int
1984: WHERE legacy_en_sua_int_id = l_en_sua_cur_rec.legacy_en_sua_int_id;
1985: ELSE
1986: l_last_updated_by := get_last_updated_by;
1987: l_last_update_date := get_last_update_date;

Line 1993: UPDATE igs_en_lgcy_sua_int

1989: l_request_id := get_request_id;
1990: l_program_application_id := get_program_application_id;
1991: l_program_id := get_program_id;
1992: l_program_update_date := get_program_update_date;
1993: UPDATE igs_en_lgcy_sua_int
1994: SET import_status = DECODE(l_return_status,
1995: 'S','I',
1996: 'U','E',
1997: 'W','W',