APPS.IGS_EN_VAL_SCA dependencies on IGS_EN_ATD_TYPE_LOAD

Line 399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;

395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS
402: SELECT sca.attendance_type,
403: sca.student_confirmed_ind

Line 400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS
402: SELECT sca.attendance_type,
403: sca.student_confirmed_ind
404: FROM IGS_EN_STDNT_PS_ATT sca

Line 454: FROM IGS_EN_ATD_TYPE_LOAD atl

450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
452: SELECT atl.lower_enr_load_range,
453: atl.upper_enr_load_range
454: FROM IGS_EN_ATD_TYPE_LOAD atl
455: WHERE atl.cal_type = cp_load_cal_type AND
456: atl.attendance_type = cp_attendance_type;
457: BEGIN
458: -- Set the default message number

Line 1472: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;

1468: v_upper_enr_load_range IGS_EN_ATD_TYPE.upper_enr_load_range%TYPE;
1469: v_validation_failed BOOLEAN;
1470: v_concat_attendance_type VARCHAR2(100);
1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
1472: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
1473: v_credit_points NUMBER;
1474: v_other_detail VARCHAR(255);
1475: CURSOR c_coo(
1476: cp_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS