APPS.IGF_SL_REL_DISB dependencies on IGS_EN_ATD_TYPE_ALL

Line 77: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,

73: FUNCTION chk_attendance(
74: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
76: p_load_seq_number igs_ca_inst_all.sequence_number%TYPE,
77: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
78: p_result OUT NOCOPY VARCHAR2
79: )
80: RETURN BOOLEAN
81: AS

Line 91: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE

87: --------------------------------------------------------------------------------------------
88:
89: CURSOR cur_get_range(
90: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
91: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE
92: )
93: IS
94: SELECT upper_enr_load_range
95: FROM igs_en_atd_type_load

Line 100: l_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;

96: WHERE cal_type = p_load_cal_type
97: AND attendance_type = p_min_att_type;
98:
99: get_range_rec cur_get_range%ROWTYPE;
100: l_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
101: l_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
102: l_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
103: l_credit_pts NUMBER;
104: l_fte VARCHAR2(10);

Line 101: l_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;

97: AND attendance_type = p_min_att_type;
98:
99: get_range_rec cur_get_range%ROWTYPE;
100: l_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
101: l_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
102: l_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
103: l_credit_pts NUMBER;
104: l_fte VARCHAR2(10);
105: BEGIN

Line 102: l_key_att_type igs_en_atd_type_all.attendance_type%TYPE;

98:
99: get_range_rec cur_get_range%ROWTYPE;
100: l_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
101: l_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
102: l_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
103: l_credit_pts NUMBER;
104: l_fte VARCHAR2(10);
105: BEGIN
106: OPEN cur_get_range(p_load_cal_type, p_min_att_type);