APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGY_SUSA_INT

Line 1013: FROM igs_en_lgy_susa_int

1009: p_deletion_flag IN BOOLEAN
1010: ) AS
1011: CURSOR c_en_susa IS
1012: SELECT *
1013: FROM igs_en_lgy_susa_int
1014: WHERE batch_id = p_batch_id
1015: AND import_status IN ('U','R')
1016: ORDER BY person_number ASC,
1017: program_cd ASC

Line 1131: DELETE FROM igs_en_lgy_susa_int

1127: p_int_table_code => g_cst_en_susa,
1128: p_int_table_id => l_en_susa_cur_rec.legacy_en_susa_int_id
1129: );
1130: -- delete the interface record
1131: DELETE FROM igs_en_lgy_susa_int
1132: WHERE legacy_en_susa_int_id = l_en_susa_cur_rec.legacy_en_susa_int_id;
1133: ELSE
1134: l_last_updated_by := get_last_updated_by;
1135: l_last_update_date := get_last_update_date;

Line 1141: UPDATE igs_en_lgy_susa_int

1137: l_request_id := get_request_id;
1138: l_program_application_id := get_program_application_id;
1139: l_program_id := get_program_id;
1140: l_program_update_date := get_program_update_date;
1141: UPDATE igs_en_lgy_susa_int
1142: SET import_status = DECODE(l_return_status,
1143: 'S','I',
1144: 'U','E',
1145: 'W','W',