APPS.IGS_EN_LGCY_PRC dependencies on IGS_AS_LGCY_SUARC_INT

Line 473: FROM igs_as_lgcy_suarc_int suarc

469: ) AS
470:
471: CURSOR c_as_suarc IS
472: SELECT suarc.*
473: FROM igs_as_lgcy_suarc_int suarc
474: WHERE batch_id = p_batch_id AND import_status IN ('U', 'R')
475: ORDER BY suarc.person_number ASC
476: FOR UPDATE NOWAIT;
477:

Line 561: DELETE FROM igs_as_lgcy_suarc_int

557: p_int_table_code => g_cst_en_sua,
558: p_int_table_id => l_as_suarefcd_rec.LEGACY_SUAR_INT_ID
559: );
560: -- delete the interface record
561: DELETE FROM igs_as_lgcy_suarc_int
562: WHERE LEGACY_SUAR_INT_ID = l_as_suarefcd_rec.LEGACY_SUAR_INT_ID;
563: ELSE
564: l_last_updated_by := get_last_updated_by;
565: l_last_update_date := get_last_update_date;

Line 571: UPDATE igs_as_lgcy_suarc_int

567: l_request_id := get_request_id;
568: l_program_application_id := get_program_application_id;
569: l_program_id := get_program_id;
570: l_program_update_date := get_program_update_date;
571: UPDATE igs_as_lgcy_suarc_int
572: SET import_status = DECODE(l_return_status,
573: 'S','I',
574: 'U','E',
575: 'W','W',