APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_EV_FORM_STAT

Line 2705: FROM igs_pe_ev_form_stat

2701: to_char(prgm_end_date,'YYYY-MM-DD') prgm_end_date,
2702: remarks ,
2703: termination_reason ,
2704: end_program_reason
2705: FROM igs_pe_ev_form_stat
2706: WHERE ev_form_id = p_person_rec.form_id
2707: AND ev_form_stat_id NOT IN
2708: ( SELECT NVL(form_status_id,0)
2709: FROM igs_sv_prgms_info prg,

Line 10396: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st

10392: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt
10394: WHERE pr.party_id = fr.person_id AND fr.form_effective_date <= trunc(sysdate)
10395: AND fr.ev_form_id NOT IN
10396: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st
10397: WHERE st.action_type IN ('TR','ED')
10398: AND st.ev_form_id = fr.ev_form_id
10399: AND st.ev_form_stat_id IN
10400: ( SELECT NVL(prs.form_status_id,0) FROM igs_sv_prgms_info prs, igs_sv_persons pr