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_NSC_PKG dependencies on IGS_CA_STAT

Line 2025: cst_active CONSTANT igs_ca_stat.s_cal_status%TYPE := 'ACTIVE';

2021:
2022: l_start_date VARCHAR2(20);
2023: l_start_year VARCHAR2(10);
2024: l_non_grad_lvl VARCHAR2(1);
2025: cst_active CONSTANT igs_ca_stat.s_cal_status%TYPE := 'ACTIVE';
2026: cst_load CONSTANT igs_ca_type.s_cal_cat%TYPE := 'LOAD';
2027: l_valid_pgm VARCHAR2(1);
2028:
2029: --fetch start dateof the academic calendar for which the job is run

Line 2043: igs_ca_stat cs

2039: ) IS
2040: SELECT ci.cal_type, ci.SEQUENCE_NUMBER
2041: FROM igs_ca_type ct,
2042: igs_ca_inst ci,
2043: igs_ca_stat cs
2044: WHERE ci.cal_type = ct.cal_type
2045: AND ct.s_cal_cat = 'ACADEMIC'
2046: AND ct.closed_ind = 'N'
2047: AND ci.cal_status = cs.cal_status

Line 2062: igs_ca_stat cs,

2058: SELECT ci.cal_type,
2059: ci.sequence_number
2060: FROM igs_ca_type ct,
2061: igs_ca_inst ci,
2062: igs_ca_stat cs,
2063: igs_ca_inst_rel cir
2064: WHERE ct.closed_ind = 'N' AND
2065: cs.s_cal_status = cst_active AND
2066: ci.cal_status = cs.cal_status AND