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_AD_APPL_EVAL_PKG dependencies on IGS_AD_APPL_ARP

Line 717: FROM igs_ad_appl_arp a, igs_ad_apl_rev_prf_all r

713: SELECT
714: a.appl_rev_profile_id,
715: a.appl_revprof_revgr_id,
716: r.SEQUENTIAL_CONCURRENT_IND
717: FROM igs_ad_appl_arp a, igs_ad_apl_rev_prf_all r
718: WHERE a.person_id = x_person_id
719: AND a.admission_appl_number = x_admission_appl_number
720: And a.nominated_course_cd = x_nominated_course_cd
721: And a.sequence_number = x_sequence_number

Line 750: l_appl_revprof_revgr_id igs_ad_appl_arp.APPL_REVPROF_REVGR_ID%TYPE;

746:
747:
748: l_eval_num NUMBER := 0;
749: l_appl_revprof_id igs_ad_apl_rev_prf_all.appl_rev_profile_id%TYPE;
750: l_appl_revprof_revgr_id igs_ad_appl_arp.APPL_REVPROF_REVGR_ID%TYPE;
751: l_seq_conc_ind igs_ad_apl_rev_prf_all.SEQUENTIAL_CONCURRENT_IND%TYPE;
752:
753: l_person_id NUMBER;
754: l_person_name VARCHAR2(320);