DBA Data[Home] [Help]

APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_ANL_LOAD_U_LN

Line 895: FROM IGS_PS_ANL_LOAD_U_LN calul,

891: WHERE crv.course_cd = p_course_cd AND
892: crv.version_number = p_version_number;
893: CURSOR c_calul_cal IS
894: SELECT cal.annual_load_val
895: FROM IGS_PS_ANL_LOAD_U_LN calul,
896: IGS_PS_ANL_LOAD cal
897: WHERE calul.course_cd = p_course_cd AND
898: calul.crv_version_number = p_version_number AND
899: calul.effective_start_dt <= SYSDATE AND

Line 944: -- Method 3. By using the IGS_PS_ANL_LOAD_U_LN structure, which

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
942: -- credit point total. This is used when no annual load unit link is
943: -- defined (refer method 3).
944: -- Method 3. By using the IGS_PS_ANL_LOAD_U_LN structure, which
945: -- explicitely links the unit version to a IGS_PS_ANL_LOAD record, dictating
946: -- the annual load figure.
947: -- 1. Check whether course version has a 'standard' annual load across all
948: -- years - this is done by searching for the existence of a current