APPS.IGS_EN_GEN_016 dependencies on IGS_CA_TYPE

Line 94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir

90: --
91: CURSOR get_load_cal_inst (p_acad_cal_type IN VARCHAR2 , p_acad_ci_sequence_number IN NUMBER ,
92: p_start_dt IN DATE , p_end_dt IN DATE )IS
93: SELECT ci.cal_type , ci.start_dt , ci.end_dt , ci.sequence_number
94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir
95: WHERE ct.cal_type = ci.cal_type
96: AND ct.s_cal_cat = 'LOAD'
97: AND cir.sup_cal_type = p_acad_cal_type
98: AND cir.sup_ci_sequence_number = p_acad_ci_sequence_number

Line 159: l_acad_cal_type igs_ca_type.cal_type%TYPE;

155: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
156:
157: l_prgm_inactive_chk VARCHAR2(1) := 'N';
158:
159: l_acad_cal_type igs_ca_type.cal_type%TYPE;
160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;

Line 163: l_load_cal_type igs_ca_type.cal_type%TYPE;

159: l_acad_cal_type igs_ca_type.cal_type%TYPE;
160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:

Line 165: l_teach_cal_type igs_ca_type.cal_type%TYPE;

161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:
168: l_error_status VARCHAR2(1);
169: l_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;