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_GEN_011 dependencies on IGS_AD_PRCS_CAT_LTR

Line 813: FROM igs_ad_prcs_cat_ltr apcl,

809: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,
810: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
811: ) IS
812: SELECT apcl.letter_reference_number
813: FROM igs_ad_prcs_cat_ltr apcl,
814: igs_co_s_ltr slet
815: WHERE apcl.admission_cat = cp_admission_cat
816: AND apcl.s_admission_process_type = cp_s_admission_process_type
817: AND apcl.correspondence_type = cp_correspondence_type

Line 857: -- Find the letter by looking at IGS_AD_PRCS_CAT_LTR.

853: --
854: v_message_name := NULL;
855: l_org_id := igs_ge_gen_003.get_org_id;
856: --
857: -- Find the letter by looking at IGS_AD_PRCS_CAT_LTR.
858: --
859: OPEN c_apcl_slet (
860: p_admission_cat,
861: p_s_admission_process_type,