[Home] [Help]
61: ci.sequence_number = p_acad_ci_sequence_number AND
62: ((sca.course_rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt) OR
63: (sca.course_rqrmnts_complete_dt >
64: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
65: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
66: p_person_id,
67: p_course_cd,
68: p_include_fail_grade_ind,
69: p_enrolled_units_ind,
89: ci.sequence_number = p_acad_ci_sequence_number AND
90: ((sca.course_rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt) OR
91: (sca.course_rqrmnts_complete_dt >
92: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
93: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
94: p_person_id,
95: p_course_cd,
96: p_include_fail_grade_ind,
97: p_enrolled_units_ind,
294: ci.sequence_number = p_acad_ci_sequence_number AND
295: ((sca.commencement_dt BETWEEN ci.start_dt AND ci.end_dt) OR
296: (sca.commencement_dt >
297: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
298: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
299: p_person_id,
300: p_course_cd,
301: p_include_fail_grade_ind,
302: p_enrolled_units_ind,
431: (((susa.selection_dt BETWEEN ci.start_dt AND ci.end_dt) OR
432: (susa.rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt)) OR
433: (susa.selection_dt >
434: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
435: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
436: p_person_id,
437: p_course_cd,
438: p_include_fail_grade_ind,
439: p_enrolled_units_ind,
441: p_exclude_unit_category,
442: p_include_related_crs_ind)) OR
443: (susa.rqrmnts_complete_dt >
444: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
445: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
446: p_person_id,
447: p_course_cd,
448: p_include_fail_grade_ind,
449: p_enrolled_units_ind,
989: ci.CAL_TYPE = p_acad_cal_type AND
990: ci.sequence_number = p_acad_ci_sequence_number AND
991: ((sci.start_dt BETWEEN ci.start_dt AND ci.end_dt) OR
992: (sci.start_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
993: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
994: p_person_id,
995: p_course_cd,
996: p_include_fail_grade_ind,
997: p_enrolled_units_ind,
1017: ci.CAL_TYPE = p_acad_cal_type AND
1018: ci.sequence_number = p_acad_ci_sequence_number AND
1019: ((sca.lapsed_dt BETWEEN ci.start_dt AND ci.end_dt) OR
1020: (sca.lapsed_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
1021: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
1022: p_person_id,
1023: p_course_cd,
1024: p_include_fail_grade_ind,
1025: p_enrolled_units_ind,
1045: ci.CAL_TYPE = p_acad_cal_type AND
1046: ci.sequence_number = p_acad_ci_sequence_number AND
1047: ((sca.discontinued_dt BETWEEN ci.start_dt AND ci.end_dt) OR
1048: (sca.discontinued_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
1049: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
1050: p_person_id,
1051: p_course_cd,
1052: p_include_fail_grade_ind,
1053: p_enrolled_units_ind,
1527: sequence_number = p_acad_ci_sequence_number;
1528: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1529: SELECT 'x'
1530: FROM dual
1531: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1532: p_person_id,
1533: p_course_cd,
1534: p_include_fail_grade_ind,
1535: p_enrolled_units_ind,
1694: sequence_number = p_acad_ci_sequence_number;
1695: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1696: SELECT 'x'
1697: FROM dual
1698: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1699: p_person_id,
1700: p_course_cd,
1701: p_include_fail_grade_ind,
1702: p_enrolled_units_ind,
1873: sequence_number = p_acad_ci_sequence_number;
1874: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1875: SELECT 'x'
1876: FROM dual
1877: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1878: p_person_id,
1879: p_course_cd,
1880: p_include_fail_grade_ind,
1881: p_enrolled_units_ind,