APPS.IGS_RE_GEN_001 dependencies on IGS_CA_INST_REL

Line 140: -- percentage field held in the IGS_CA_INST_REL table for the

136: RETURN NUMBER AS
137: gv_other_detail VARCHAR2(255);
138: BEGIN -- resp_clc_load_eftsu
139: -- Calculate the maximum EFTSU applicable in a load calendar according to the
140: -- percentage field held in the IGS_CA_INST_REL table for the
141: -- relationship between the academic and load calendar instances.
142: DECLARE
143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;

Line 144: IGS_CA_INST_REL.load_research_percentage%TYPE;

140: -- percentage field held in the IGS_CA_INST_REL table for the
141: -- relationship between the academic and load calendar instances.
142: DECLARE
143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;
145: CURSOR c_cir IS
146: SELECT cir.load_research_percentage
147: FROM IGS_CA_INST_REL cir
148: WHERE sup_cal_type = p_acad_cal_type AND

Line 147: FROM IGS_CA_INST_REL cir

143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;
145: CURSOR c_cir IS
146: SELECT cir.load_research_percentage
147: FROM IGS_CA_INST_REL cir
148: WHERE sup_cal_type = p_acad_cal_type AND
149: sup_ci_sequence_number = p_acad_ci_sequence_number AND
150: sub_cal_type = p_load_cal_type AND
151: sub_ci_sequence_number = p_load_ci_sequence_number;