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_UC_EXPUNGE_APP dependencies on IGS_PE_PERSON_BASE_V

Line 251: CURSOR cur_per_no (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

247: SELECT igs_ad_interface_ctl_s.NEXTVAL
248: FROM dual ;
249:
250: --To get the Person Number FOR the give person ID
251: CURSOR cur_per_no (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
252: SELECT person_number
253: FROM igs_pe_person_base_v
254: WHERE person_id = cp_person_id;
255:

Line 253: FROM igs_pe_person_base_v

249:
250: --To get the Person Number FOR the give person ID
251: CURSOR cur_per_no (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
252: SELECT person_number
253: FROM igs_pe_person_base_v
254: WHERE person_id = cp_person_id;
255:
256: --To get the Person alternate ID record to End Date
257: CURSOR cur_alt_pers_id (cp_app_no igs_uc_wrong_app.app_no%TYPE) IS

Line 293: l_person_no igs_pe_person_base_v.person_number%TYPE;

289: l_dec_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
290: l_interface_mkdes_id igs_ad_admde_int_all.interface_mkdes_id%TYPE;
291: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE;
292: l_error_message fnd_new_messages.message_text%TYPE;
293: l_person_no igs_pe_person_base_v.person_number%TYPE;
294: l_dec_imp_err fnd_new_messages.message_text%TYPE;
295: l_choice_no igs_uc_app_choices.choice_no%TYPE;
296:
297: --Table Type to hold the batch_id created for diferrent system cycle calendars.