DBA Data[Home] [Help]

APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_FELONY_DTLS

Line 3882: FROM igs_pe_felony_dtls

3878:
3879: CURSOR c_data IS
3880: SELECT felony_details_id conviction_id,
3881: disp_action_info criminal_remarks
3882: FROM igs_pe_felony_dtls
3883: WHERE person_id = p_person_rec.person_id
3884: AND convict_ind ='Y'
3885: AND felony_details_id NOT IN
3886: ( SELECT conviction_id