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_AS_SS_DOC_REQUEST dependencies on IGS_CA_INST

Line 1483: FROM igs_ca_inst ci

1479: --Verify if the SYSDATE is between start and End date of the Academic calendar.
1480: BEGIN
1481: SELECT 1
1482: INTO lninperd
1483: FROM igs_ca_inst ci
1484: WHERE SYSDATE BETWEEN ci.start_dt AND ci.end_dt
1485: AND cal_type = plan_subs.cal_type
1486: AND sequence_number = plan_subs.ci_sequence_number;
1487: EXCEPTION

Line 2029: FROM igs_ca_inst_all ci,

2025: daiv.cal_type = ci.cal_type AND
2026: daiv.ci_sequence_number= ci.sequence_number AND
2027: daiv.dt_alias = secc.load_effect_dt_alias),
2028: ci.start_dt) load_effect_dt
2029: FROM igs_ca_inst_all ci,
2030: igs_ca_type cat,
2031: igs_ca_stat cs
2032: WHERE
2033: ci.end_dt >= TRUNC(SYSDATE) AND

Line 2080: FROM igs_ca_inst_all ci,

2076: daiv.dt_alias = secc.load_effect_dt_alias
2077: ),
2078: ci.start_dt
2079: ) load_effect_dt
2080: FROM igs_ca_inst_all ci,
2081: igs_ca_type cat,
2082: igs_ca_stat cs
2083: WHERE
2084: ci.end_dt >= TRUNC(SYSDATE) AND

Line 2124: FROM igs_ca_inst_all ci,

2120: daiv.dt_alias = secc.load_effect_dt_alias
2121: ),
2122: ci.start_dt
2123: ) load_effect_dt
2124: FROM igs_ca_inst_all ci,
2125: igs_ca_type cat,
2126: igs_ca_stat cs
2127: WHERE
2128: ci.end_dt < TRUNC(SYSDATE) AND