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.IGF_AW_COA_GEN dependencies on IGS_PS_OFR_OPT_ALL

Line 2244: FROM igs_ps_ofr_opt_all offering

2240: CURSOR c_chk_prog_offer (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2241: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE)
2242: IS
2243: SELECT 'x'
2244: FROM igs_ps_ofr_opt_all offering
2245: WHERE offering.course_cd = cp_program_code
2246: AND offering.location_cd = cp_location_code;
2247:
2248: l_chk_prog_offer c_chk_prog_offer%ROWTYPE;

Line 2259: FROM igs_ps_ofr_opt_all offering,

2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,
2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
2257: IS
2258: SELECT 'x'
2259: FROM igs_ps_ofr_opt_all offering,
2260: igs_ps_ofr_pat offering_pattern
2261: WHERE offering.course_cd = cp_program_code
2262: AND offering.location_cd = cp_location_code
2263: AND offering.attendance_mode = cp_attend_mode