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_LOOKUP_VALUES

Line 2770: ( SELECT lookup_code FROM igs_lookup_values

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
2772: enabled_flag ='Y' AND
2773: (tag= p_visa OR tag= 'FM')
2774: );

Line 12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12332:
12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12334: IS
12335: SELECT hz.party_number prsn_num, lkp.meaning info
12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12337: WHERE svbs.batch_id = cp_batch_id
12338: AND svbs.action_code = 'NEW'
12339: AND svbs.person_id = hz.party_id
12340: AND svbs.TAG_CODE = lkp.lookup_code

Line 12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12342:
12343: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12344: IS
12345: SELECT hz.party_number prsn_num, lkp.meaning info
12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12347: WHERE svbs.batch_id = cp_batch_id
12348: AND svbs.action_code <> 'NEW'
12349: AND svbs.person_id = hz.party_id
12350: AND svbs.TAG_CODE = lkp.lookup_code