APPS.IGS_EN_NSC_PKG dependencies on IGS_CA_TYPE

Line 261: FROM igs_ca_type_v

257: WHERE sub_cal_type = l_load_cal_type
258: AND sub_ci_sequence_number = l_load_cal_seq
259: AND sup_cal_type IN
260: (SELECT cal_type
261: FROM igs_ca_type_v
262: WHERE s_cal_cat='ACADEMIC');
263:
264:
265: CURSOR c_grad_type IS

Line 2026: cst_load CONSTANT igs_ca_type.s_cal_cat%TYPE := 'LOAD';

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
2030: CURSOR cur_strt_date(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) is

Line 2041: FROM igs_ca_type ct,

2037: -- acad cal for which the job is run .
2038: CURSOR acad_cal(cp_start_year VARCHAR2
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'

Line 2060: FROM igs_ca_type ct,

2056: cp_cal_type IGS_CA_INST.cal_type%TYPE,
2057: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
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