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_ST_GEN_002 dependencies on IGS_ST_GVTSEMLOAD_CA

Line 200: FROM IGS_ST_GVTSEMLOAD_CA gslc

196: gslov.ci_sequence_number = p_load_ci_sequence_number AND
197: gslov.teach_cal_type = p_teach_cal_type;
198: CURSOR c_gslc IS
199: SELECT gslc.govt_semester
200: FROM IGS_ST_GVTSEMLOAD_CA gslc
201: WHERE gslc.submission_yr = p_submission_yr AND
202: gslc.submission_number = p_submission_number AND
203: gslc.cal_type = p_load_cal_type AND
204: gslc.ci_sequence_number = p_load_ci_sequence_number;

Line 221: -- get the government value from the IGS_ST_GVTSEMLOAD_CA

217: CLOSE c_gslov;
218: RETURN v_govt_sem;
219: END IF;
220: CLOSE c_gslov;
221: -- get the government value from the IGS_ST_GVTSEMLOAD_CA
222: -- table
223: OPEN c_gslc;
224: FETCH c_gslc INTO v_govt_sem;
225: -- check if a record has been found