eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_NONIMG_STAT

Line 2682: FROM igs_pe_nonimg_stat

2678: remarks,
2679: termination_reason,
2680: print_flag, --prbhardw
2681: cancel_flag
2682: FROM igs_pe_nonimg_stat
2683: WHERE nonimg_form_id = p_person_rec.form_id
2684: AND nonimg_stat_id NOT IN
2685: ( SELECT NVL(form_status_id,0)
2686: FROM igs_sv_prgms_info prg,

Line 2765: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS

2761: SELECT visa_type
2762: FROM IGS_PE_NONIMG_FORM
2763: WHERE nonimg_form_id = p_person_rec.form_id;
2764:
2765: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
2766: SELECT COUNT(1)
2767: FROM igs_pe_nonimg_stat
2768: WHERE nonimg_form_id = p_person_rec.form_id
2769: AND p_term_reason NOT IN

Line 2767: FROM igs_pe_nonimg_stat

2763: WHERE nonimg_form_id = p_person_rec.form_id;
2764:
2765: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
2766: SELECT COUNT(1)
2767: FROM igs_pe_nonimg_stat
2768: WHERE nonimg_form_id = p_person_rec.form_id
2769: AND p_term_reason NOT IN
2770: ( SELECT lookup_code FROM igs_lookup_values
2771: WHERE lookup_type ='PE_SV_TERMINATE_REASON' AND

Line 10421: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st

10417: FROM igs_pe_nonimg_form fr, hz_parties pr
10418: WHERE pr.party_id = fr.person_id
10419: AND fr.form_effective_date <= trunc(sysdate)
10420: AND fr.nonimg_form_id NOT IN
10421: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st
10422: WHERE st.action_type IN ('T','C')
10423: AND st.nonimg_form_id = fr.nonimg_form_id
10424: AND st.nonimg_stat_id IN
10425: ( SELECT NVL(prs.form_status_id,0)

Line 10486: FROM igs_pe_nonimg_stat

10482:
10483: ---prbhardw
10484: CURSOR c_prgm_print_flag (p_form_id NUMBER) IS
10485: SELECT decode(print_flag,'Y','1','0') print_form
10486: FROM igs_pe_nonimg_stat
10487: WHERE nonimg_form_id = p_form_id
10488: AND p_batch_type = 'I'
10489: AND action_type = 'E';
10490: