APPS.IGS_EN_GEN_003 dependencies on IGS_CA_INST_REL

Line 226: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

222: BEGIN
223: DECLARE
224: v_applicable_enrolment_cat VARCHAR2(255);
225: v_crs_applicable_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
226: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
227: v_first_record BOOLEAN;
228: v_first_time BOOLEAN;
229: v_set_cal BOOLEAN;
230: v_crs_commencement_type VARCHAR2(10);

Line 270: FROM IGS_CA_INST_REL

266: cp_sup_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type
270: FROM IGS_CA_INST_REL
271: WHERE sup_cal_type = cp_sup_cal_type AND
272: sup_ci_sequence_number = cp_sup_ci_sequence_number AND
273: sub_cal_type = cp_sub_cal_type AND
274: sub_ci_sequence_number = cp_sub_ci_sequence_number;

Line 468: FROM IGS_CA_INST_REL cir,

464: cst_enrolment CONSTANT VARCHAR2(10) := 'ENROLMENT';
465: CURSOR c_cir IS
466: SELECT cir.sub_cal_type,
467: cir.sub_ci_sequence_number
468: FROM IGS_CA_INST_REL cir,
469: IGS_CA_INST ci,
470: IGS_CA_TYPE cat,
471: IGS_CA_STAT cs
472: WHERE cir.sup_cal_type = p_adm_cal_type AND