APPS.IGS_EN_LGCY_PRC dependencies on IGS_HE_LGY_SUSA_INT

Line 2232: FROM igs_he_lgy_susa_int

2228: -- changes described by HEFD350.
2229: -----------------------------------------------------------------------------------------------------
2230: CURSOR c_he_susa IS
2231: SELECT *
2232: FROM igs_he_lgy_susa_int
2233: WHERE batch_id = p_batch_id
2234: AND import_status IN ('U','R')
2235: ORDER BY person_number ASC,
2236: program_cd ASC

Line 2359: DELETE FROM igs_he_lgy_susa_int

2355: p_int_table_code => g_cst_he_susa,
2356: p_int_table_id => l_he_susa_cur_rec.legacy_hesa_susa_int_id
2357: );
2358: -- delete the interface record
2359: DELETE FROM igs_he_lgy_susa_int
2360: WHERE legacy_hesa_susa_int_id = l_he_susa_cur_rec.legacy_hesa_susa_int_id ;
2361: ELSE
2362: l_last_updated_by := get_last_updated_by;
2363: l_last_update_date := get_last_update_date;

Line 2369: UPDATE igs_he_lgy_susa_int

2365: l_request_id := get_request_id;
2366: l_program_application_id := get_program_application_id;
2367: l_program_id := get_program_id;
2368: l_program_update_date := get_program_update_date;
2369: UPDATE igs_he_lgy_susa_int
2370: SET import_status = DECODE(l_return_status,
2371: 'S','I',
2372: 'U','E',
2373: 'W','W',