APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_COURSE

Line 937: -- Method 1. If the IGS_PS_COURSE has a standard annual load across all years then

933: BEGIN
934: -- Get the annual load figure of a student unit attempt within a course
935: -- version.
936: -- This figure may come from one of three places:
937: -- Method 1. If the IGS_PS_COURSE has a standard annual load across all years then
938: -- the IGS_PS_VER.std_annual_load figure is used. This is defined by the
939: -- non-existence of a current IGS_PS_ANL_LOAD record for the course version.
940: -- Method 2. By interrogating the IGS_PS_ANL_LOAD structure to determine
941: -- which annual load value is applicable, given the students current passed

Line 1094: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,

1090: -- CI.sequence_number,
1091: -- 'N') = 'Y');
1092: CURSOR c_stu_unit_atmpt(
1093: cp_person_id IGS_PE_PERSON.person_id%TYPE,
1094: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
1095: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1096: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1097: SELECT SUA.unit_cd,
1098: SUA.version_number,