APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_EV_FORM_STAT

Line 3510: FROM igs_pe_ev_form_stat

3506: to_char(prgm_end_date,'YYYY-MM-DD') prgm_end_date,
3507: remarks ,
3508: termination_reason ,
3509: end_program_reason
3510: FROM igs_pe_ev_form_stat
3511: WHERE ev_form_id = p_person_rec.form_id
3512: AND ev_form_stat_id NOT IN
3513: ( SELECT NVL(form_status_id,0)
3514: FROM igs_sv_prgms_info prg,

Line 11535: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st

11531: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
11532: FROM igs_pe_ev_form fr, hz_parties pr
11533: WHERE pr.party_id = fr.person_id AND fr.form_effective_date <= trunc(sysdate)
11534: AND fr.ev_form_id NOT IN
11535: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st
11536: WHERE st.action_type IN ('TR','ED')
11537: AND st.ev_form_id = fr.ev_form_id
11538: AND st.ev_form_stat_id IN
11539: ( SELECT NVL(prs.form_status_id,0) FROM igs_sv_prgms_info prs, igs_sv_persons pr