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_EN_GEN_006 dependencies on IGS_EN_GEN_014

Line 149: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

145: WHERE cat.cal_type = ci1.cal_type AND
146: cat.s_cal_cat = cst_academic AND
147: ci1.cal_status = cs.cal_status AND
148: cs.s_cal_status = cst_active AND
149: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
150: ci1.cal_type,
151: ci1.sequence_number,
152: p_load_cal_type,
153: p_load_sequence_number,

Line 168: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

164: sua.unit_attempt_status IN (
165: cst_enrolled,
166: cst_completed,
167: cst_discontin) AND
168: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
169: cp_ci_cal_type,
170: cp_ci_sequence_number,
171: sua.cal_type,
172: sua.ci_sequence_number,

Line 305: (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(cp_cal_type,

301: CS.s_cal_status = cst_active AND
302: CI.cal_status = CS.cal_status AND
303: CT.s_cal_cat = cst_load AND
304: CI.cal_type = CT.cal_type AND
305: (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(cp_cal_type,
306: cp_sequence_number,
307: CI.cal_type,
308: CI.sequence_number,
309: 'N') = 'Y')