APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_CA_INST

Line 234: l_cal_type igs_ca_inst.cal_type%TYPE;

230: WHERE teach_cal_type= cp_teach_cal_type
231: AND teach_ci_sequence_number= cp_teach_ci_sequence_number;
232:
233:
234: l_cal_type igs_ca_inst.cal_type%TYPE;
235: l_ci_seq_number igs_ca_inst.sequence_number%TYPE;
236: l_course_cd igs_ps_ver.course_cd%TYPE;
237: l_course_version igs_ps_ver.version_number%TYPE;
238: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

Line 235: l_ci_seq_number igs_ca_inst.sequence_number%TYPE;

231: AND teach_ci_sequence_number= cp_teach_ci_sequence_number;
232:
233:
234: l_cal_type igs_ca_inst.cal_type%TYPE;
235: l_ci_seq_number igs_ca_inst.sequence_number%TYPE;
236: l_course_cd igs_ps_ver.course_cd%TYPE;
237: l_course_version igs_ps_ver.version_number%TYPE;
238: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
239: l_unit_version igs_ps_unit_ver.version_number%TYPE;

Line 885: igs_ca_inst ci

881: -- for non-imig student alone. Bug 5435397
882: -------------------------------------------------------------------------------------------- */
883: --Cursor to get the calendar end date,person id for a given eligibility override.
884: CURSOR cur_elgb_end_dt IS SELECT end_dt,person_id, ci.cal_type, ci.sequence_number FROM igs_en_elgb_ovr elgb,
885: igs_ca_inst ci
886: WHERE elgb.elgb_override_id = p_elgb_override_id
887: AND elgb.cal_type = ci.cal_type
888: AND elgb.ci_sequence_number = ci.sequence_number;
889: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;

889: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
890: l_rowid VARCHAR2(30);
891: l_elgb_ovr_step_id NUMBER;
892: l_step_override_limit NUMBER := NULL;
893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
894: l_cal_type igs_ca_inst.cal_type%TYPE;
895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);

Line 894: l_cal_type igs_ca_inst.cal_type%TYPE;

890: l_rowid VARCHAR2(30);
891: l_elgb_ovr_step_id NUMBER;
892: l_step_override_limit NUMBER := NULL;
893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
894: l_cal_type igs_ca_inst.cal_type%TYPE;
895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;

Line 895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

891: l_elgb_ovr_step_id NUMBER;
892: l_step_override_limit NUMBER := NULL;
893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
894: l_cal_type igs_ca_inst.cal_type%TYPE;
895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;