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_BATCH_PROCESS_PKG dependencies on IGS_PE_NONIMG_STAT

Line 3487: FROM igs_pe_nonimg_stat

3483: remarks,
3484: termination_reason,
3485: print_flag, --prbhardw
3486: cancel_flag
3487: FROM igs_pe_nonimg_stat
3488: WHERE nonimg_form_id = p_person_rec.form_id
3489: AND nonimg_stat_id NOT IN
3490: ( SELECT NVL(form_status_id,0)
3491: FROM igs_sv_prgms_info prg,

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

3568: SELECT visa_type
3569: FROM IGS_PE_NONIMG_FORM
3570: WHERE nonimg_form_id = p_person_rec.form_id;
3571:
3572: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
3573: SELECT COUNT(1)
3574: FROM igs_pe_nonimg_stat
3575: WHERE nonimg_form_id = p_person_rec.form_id
3576: AND p_term_reason NOT IN

Line 3574: FROM igs_pe_nonimg_stat

3570: WHERE nonimg_form_id = p_person_rec.form_id;
3571:
3572: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
3573: SELECT COUNT(1)
3574: FROM igs_pe_nonimg_stat
3575: WHERE nonimg_form_id = p_person_rec.form_id
3576: AND p_term_reason NOT IN
3577: ( SELECT lookup_code FROM igs_lookup_values
3578: WHERE lookup_type ='PE_SV_TERMINATE_REASON' AND

Line 11565: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st

11561: FROM igs_pe_nonimg_form fr, hz_parties pr
11562: WHERE pr.party_id = fr.person_id
11563: AND fr.form_effective_date <= trunc(sysdate)
11564: AND fr.nonimg_form_id NOT IN
11565: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st
11566: WHERE st.action_type IN ('T','C')
11567: AND st.nonimg_form_id = fr.nonimg_form_id
11568: AND st.nonimg_stat_id IN
11569: ( SELECT NVL(prs.form_status_id,0)

Line 11634: FROM igs_pe_nonimg_stat

11630:
11631: ---prbhardw
11632: CURSOR c_prgm_print_flag (p_form_id NUMBER) IS
11633: SELECT decode(print_flag,'Y','1','0') print_form
11634: FROM igs_pe_nonimg_stat
11635: WHERE nonimg_form_id = p_form_id
11636: AND p_batch_type = 'I'
11637: AND action_type = 'E';
11638: