APPS.IGS_SS_ENR_DETAILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

SELECT
 uoo_id,
 NVL(d.description,'-')||'
'||NVL(b.description,'-')||'
'||NVL(c.description,'-') location_description,
 NVL(b.location_cd,'-')||'
'||NVL(b.building_cd,'-')||'
'||NVL(c.room_cd,'-') location_cd
 FROM igs_ps_usec_occurs a,
     igs_ad_building b,
     igs_ad_room c,
     igs_ad_location d
 WHERE
     a.building_code = b.building_id(+) AND
     a.room_code = c.room_id(+) AND
     b.location_cd = d.location_cd(+) AND
     a.uoo_id = p_uoo_id
ORDER BY
    b.location_cd,b.building_id,c.room_id;

Line: 68

SELECT
 uoo_id,
 NVL(DECODE(a.monday,  'Y',  'Mon',  NULL)||
 DECODE(a.tuesday,  'Y',  'Tue',  NULL)||
 DECODE(a.wednesday,  'Y',  'Wed',  NULL)||
 DECODE(a.thursday,  'Y',  'Thu',  NULL)||
 DECODE(a.friday,  'Y',  'Fri',  NULL)||
 DECODE(a.saturday,  'Y',  'Sat',  NULL)||
 DECODE(a.sunday,  'Y',  'Sun',  NULL),'-')||'
'||
 TO_CHAR(a.start_time,  'hh:miam')||'-'|| TO_CHAR(a.end_time,  'hh:miam')||'
'||
 LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) instructor_name
 FROM igs_ps_usec_occurs a,
      igs_ad_building b,
      hz_parties f
 WHERE
     a.building_code = b.building_id(+) AND
     a.instructor_id = f.party_id(+) AND
     a.uoo_id = p_uoo_id ORDER BY
     location_cd,building_id ,room_code;

Line: 107

select
a.course_attempt_status,
a.course_cd,
b.title,
a.course_cd||'-'||b.title program,
a.person_id
from igs_en_stdnt_ps_att a,igs_ps_ver b
where a.course_cd = b.course_cd
and a.version_number = b.version_number
and a.person_id = p_person_id
and nvl(a.course_attempt_status,' ') not in ('INACTIVE');

Line: 150

SELECT
 uoo_id,
 DECODE(a.monday,  'Y',  'Mon',  NULL)||
 DECODE(a.tuesday,  'Y',  'Tue',  NULL)||
 DECODE(a.wednesday,  'Y',  'Wed',  NULL)||
 DECODE(a.thursday,  'Y',  'Thu',  NULL)||
 DECODE(a.friday,  'Y',  'Fri',  NULL)||
 DECODE(a.saturday,  'Y',  'Sat',  NULL)||
 DECODE(a.sunday,  'Y',  'Sun',  NULL) CLASS_DAY,
 TO_CHAR(a.start_time,  'hh:miam')||'-'||TO_CHAR(a.end_time,  'hh:miam') CLASS_TIME,
 DECODE(a.monday,  'Y',  'Mon',  NULL)||
 DECODE(a.tuesday,  'Y',  'Tue',  NULL)||
 DECODE(a.wednesday,  'Y',  'Wed',  NULL)||
 DECODE(a.thursday,  'Y',  'Thu',  NULL)||
 DECODE(a.friday,  'Y',  'Fri',  NULL)||
 DECODE(a.saturday,  'Y',  'Sat',  NULL)||
 DECODE(a.sunday,  'Y',  'Sun',  NULL)||' '||
 TO_CHAR(a.start_time,  'hh:miam')||'-'|| TO_CHAR(a.end_time,  'hh:miam')||'
'||
 NVL(d.description,'-')||'
'||
 NVL(b.description,'-')||'  '||
 NVL(c.description,'')||'
'||
 LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) location
 FROM igs_ps_usec_occurs a,
     igs_ad_building b,
     igs_ad_room c,
     igs_ad_location d,
     hz_parties f
 WHERE
     a.building_code = b.building_id(+) AND
     a.room_code = c.room_id(+) AND
     a.instructor_id = f.party_id(+) AND
     b.location_cd = d.location_cd(+) AND
     a.uoo_id = p_uoo_id
 ORDER BY
     class_day,class_time;

Line: 218

        IS SELECT
                 uoo_id,
                 unit_section_occurrence_id usec_id,
                 start_date,
                 end_date,
                 DECODE(a.monday,  'Y',  'Mon',  NULL)
                 || DECODE(a.tuesday,  'Y',  'Tue',  NULL)
                 || DECODE(a.wednesday,  'Y',  'Wed',  NULL)
                 || DECODE(a.thursday,  'Y',  'Thu',  NULL)
                 || DECODE(a.friday,  'Y',  'Fri',  NULL)
                 || DECODE(a.saturday,  'Y',  'Sat',  NULL)
                 || DECODE(a.sunday,  'Y',  'Sun',  NULL) class_day,
                 TO_CHAR(a.start_time,  'hh:miam')||'-'||TO_CHAR(a.end_time, 'hh:miam') class_time,
                 DECODE(a.monday,  'Y',  'Mon',  NULL)
                 || DECODE(a.tuesday,  'Y',  'Tue',  NULL)
                 || DECODE(a.wednesday,  'Y',  'Wed',  NULL)
                 || DECODE(a.thursday,  'Y',  'Thu',  NULL)
                 || DECODE(a.friday,  'Y',  'Fri',  NULL)
                 || DECODE(a.saturday,  'Y',  'Sat',  NULL)
                 || DECODE(a.sunday,  'Y',  'Sun',  NULL) ||' '
                 || TO_CHAR(a.start_time,'hh:miam')||'-'||TO_CHAR(a.end_time, 'hh:miam')
                 ||'
'||NVL(b.location_cd,' ')||'
'||NVL(b.building_cd,' ') ||' '||NVL(c.room_cd,' ') location
                 FROM igs_ps_usec_occurs a,
                      igs_ad_building b,
                      igs_ad_room c
                 WHERE
                     a.building_code = b.building_id(+) AND
                     a.room_code = c.room_id(+) AND
                     a.uoo_id = p_uoo_id
                 ORDER BY class_day,class_time;

Line: 251

                SELECT
                        person_Last_name ||', '||Person_first_name||' '|| person_middle_name  instructor_name
                FROM
                        hz_parties hz,
                        igs_ps_uso_instrctrs usoi
                WHERE
                        hz.party_id = usoi.instructor_id AND
                        usoi.unit_section_occurrence_id = p_unit_section_occurence_id;

Line: 333

SELECT
 uoo_id,
 DECODE(a.monday,  'Y',  'Mon',  NULL)||
 DECODE(a.tuesday,  'Y',  'Tue',  NULL)||
 DECODE(a.wednesday,  'Y',  'Wed',  NULL)||
 DECODE(a.thursday,  'Y',  'Thu',  NULL)||
 DECODE(a.friday,  'Y',  'Fri',  NULL)||
 DECODE(a.saturday,  'Y',  'Sat',  NULL)||
 DECODE(a.sunday,  'Y',  'Sun',  NULL)||' '||
 TO_CHAR(a.start_time,  'hh:miam')||'-'||
 TO_CHAR(a.end_time,  'hh:miam')||'
'||
 LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) occurence
 FROM igs_ps_usec_occurs a,
     igs_ad_building b,
     hz_parties f
 WHERE
     a.building_code = b.building_id(+) AND
     a.instructor_id = f.party_id(+) AND
     a.uoo_id = p_uoo_id ORDER BY
     location_cd,building_id ,room_code;

Line: 373

      SELECT a.reference_code||' - '||a.reference_code_desc ref_cd
      FROM igs_ps_us_req_ref_cd a, igs_ps_usec_ref b
      WHERE b.uoo_id = cp_uoo_id
      AND a.unit_section_reference_id = b.unit_section_reference_id
      ORDER BY 1 ;

Line: 380

      SELECT unitref.REFERENCE_CODE || ' - ' || unitref.REFERENCE_CODE_DESC  ref_cd
      FROM igs_ps_unitreqref_cd unitref,
          igs_ps_unit_ofr_opt uoo
      WHERE uoo.uoo_id = cp_uoo_id
      AND   uoo.unit_cd = unitref.unit_cd
      AND   uoo.version_number = unitref.version_number
      ORDER BY 1;

Line: 436

      SELECT reference_code ||' - '|| reference_code_description ref_cd
      FROM  igs_ps_usec_ocur_ref_v
      WHERE unit_section_occurrence_id = p_uoo_id
      ORDER BY 1 ;

Line: 465

select
a.note_text,
b.crs_note_type
from igs_ge_note a, igs_ps_unit_ver_note b
where a.reference_number = b.reference_number
and b.unit_cd = p_unit_cd
and b.version_number = p_version_number
order by crs_note_type ;

Line: 494

select
a.note_text,
b.crs_note_type
from igs_ge_note a,igs_ps_unt_ofr_opt_n b
where a.reference_number = b.reference_number
and b.uoo_id = p_uoo_id
order by crs_note_type ;

Line: 546

        SELECT
                alternative_title title,
                subtitle
        FROM
                igs_en_su_attempt
        WHERE
                person_id = p_person_id AND
                course_cd = p_course_cd AND
                uoo_id = p_uoo_id;

Line: 558

        SELECT
                uref.title,
                usub.subtitle
        FROM
                igs_ps_usec_ref uref,
                igs_ps_unit_subtitle usub
        WHERE
                uref.uoo_id = p_uoo_id AND
                uref.subtitle_id = usub.subtitle_id(+);

Line: 572

        SELECT
                uv.title,
                usub.subtitle
        FROM
                igs_ps_unit_ver        uv ,
                igs_ps_unit_subtitle  usub
        WHERE
                uv.unit_cd = cp_unit_cd AND
                uv.version_number  = cp_version_number AND
                uv.subtitle_id = usub.subtitle_id(+);

Line: 584

        select unit_cd , version_number
        from igs_ps_unit_ofr_opt
        where uoo_id = cp_uoo_id;

Line: 660

        SELECT
                alternative_title title,
                subtitle
        FROM
                igs_en_su_attempt
        WHERE
                person_id = p_person_id AND
                course_cd = p_course_cd AND
                uoo_id = p_uoo_id;

Line: 671

        SELECT
                uref.title,
                usub.subtitle
        FROM
                igs_ps_usec_ref uref,
                igs_ps_unit_subtitle usub
        WHERE
                uref.uoo_id = p_uoo_id AND
                uref.subtitle_id = usub.subtitle_id(+);

Line: 683

        SELECT
                uv.title,
                usub.subtitle
        FROM
                igs_ps_unit_ver        uv ,
                igs_ps_unit_subtitle  usub
        WHERE
                uv.unit_cd = p_unit_cd AND
                uv.version_number  = p_version_number AND
                uv.subtitle_id = usub.subtitle_id(+);

Line: 745

        SELECT
                alternative_title title,
                subtitle
        FROM
                igs_en_su_attempt
        WHERE
                person_id = p_person_id AND
                course_cd = p_course_cd AND
                uoo_id = p_uoo_id;

Line: 756

        SELECT
                uref.title,
                usub.subtitle
        FROM
                igs_ps_usec_ref uref,
                igs_ps_unit_subtitle usub
        WHERE
                uref.uoo_id = p_uoo_id AND
                uref.subtitle_id = usub.subtitle_id(+);

Line: 768

        SELECT
                uv.title,
                usub.subtitle
        FROM
                igs_ps_unit_ver        uv ,
                igs_ps_unit_subtitle  usub
        WHERE
                uv.unit_cd = p_unit_cd AND
                uv.version_number  = p_version_number AND
                uv.subtitle_id = usub.subtitle_id(+);

Line: 844

        SELECT
                sua.grading_schema_code
        FROM
                igs_en_su_attempt sua
        WHERE
                sua.person_id = p_person_id AND
                sua.uoo_id = p_uoo_id AND
                sua.course_cd = p_course_cd;

Line: 855

        SELECT
                usgr.grading_schema_code
        FROM
                igs_ps_usec_grd_schm usgr
        WHERE
                usgr.uoo_id = p_uoo_id AND
                usgr.default_flag = 'Y';

Line: 865

        SELECT
                grading_schema_code
        FROM
                igs_ps_unit_grd_schm uvgr
        WHERE
                uvgr.unit_code = p_unit_cd AND
                uvgr.unit_version_number =  p_version_number AND
                uvgr.default_flag = 'Y';

Line: 925

        SELECT
                sua.gs_version_number
        FROM
                igs_en_su_attempt sua
        WHERE
                sua.person_id = p_person_id AND
                sua.uoo_id = p_uoo_id AND
                sua.course_cd = p_course_cd;

Line: 936

        SELECT
                usgr.grd_schm_version_number
        FROM
                igs_ps_usec_grd_schm usgr
        WHERE
                usgr.uoo_id = p_uoo_id AND
                usgr.default_flag = 'Y';

Line: 946

        SELECT
                grd_schm_version_number
        FROM
                igs_ps_unit_grd_schm uvgr
        WHERE
                uvgr.unit_code = p_unit_cd AND
                uvgr.unit_version_number =  p_version_number AND
                uvgr.default_flag = 'Y';

Line: 995

        SELECT
                sua.grading_schema_code,
		sua.gs_version_number
        FROM
                igs_en_su_attempt sua
        WHERE
                sua.person_id = cp_n_person_id AND
                sua.uoo_id = cp_n_uoo_id AND
                sua.course_cd = p_course_cd;

Line: 1007

        SELECT
                usgr.grading_schema_code,
		usgr.grd_schm_version_number
        FROM
                igs_ps_usec_grd_schm usgr
        WHERE
                usgr.uoo_id = cp_n_uoo_id AND
                usgr.default_flag = 'Y';

Line: 1019

        SELECT
                uvgr.grading_schema_code,
		uvgr.grd_schm_version_number
        FROM
                igs_ps_unit_grd_schm uvgr
        WHERE
                uvgr.unit_code = cp_c_unit_cd AND
                uvgr.unit_version_number =  cp_n_ver_num AND
                uvgr.default_flag = 'Y';

Line: 1032

	SELECT description
	FROM   igs_as_grd_schema
	WHERE  grading_schema_cd = cp_grd_schm
	AND    version_number = cp_ver_num;

Line: 1087

        SELECT
                sua.grading_schema_code,
		sua.gs_version_number
        FROM
                igs_en_su_attempt sua
        WHERE
                sua.person_id = cp_n_person_id AND
                sua.uoo_id = cp_n_uoo_id AND
                sua.course_cd = p_course_cd;

Line: 1099

        SELECT
                usgr.grading_schema_code,
		usgr.grd_schm_version_number
        FROM
                igs_ps_usec_grd_schm usgr
        WHERE
                usgr.uoo_id = cp_n_uoo_id AND
                usgr.default_flag = 'Y';

Line: 1111

        SELECT
                uvgr.grading_schema_code,
		uvgr.grd_schm_version_number
        FROM
                igs_ps_unit_grd_schm uvgr
        WHERE
                uvgr.unit_code = cp_c_unit_cd AND
                uvgr.unit_version_number =  cp_n_ver_num AND
                uvgr.default_flag = 'Y';

Line: 1184

        SELECT
                NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) credit_points
        FROM
                igs_ps_unit_ofr_opt uoo,
                igs_ps_usec_cps cps,
                igs_ps_unit_ver uv
        WHERE
                uoo.uoo_id=cps.uoo_id(+) AND
                uoo.uoo_id=p_uoo_id  AND
                uoo.unit_cd=uv.unit_cd AND
                uoo.version_number=uv.version_number ;

Line: 1199

        SELECT
                sua.override_enrolled_cp
        FROM
                igs_en_su_attempt     sua
        WHERE
                sua.person_id = p_person_id AND
                sua.uoo_id = p_uoo_id AND
                sua.course_cd= p_course_cd;

Line: 1259

SELECT
      pv.course_cd,
      pv.version_number,
      pv.title
FROM IGS_EN_STDNT_PS_ATT_ALL sca,
     IGS_PS_VER_ALL pv
WHERE pv.course_cd = sca.course_cd
AND   pv.version_number = igs_en_spa_terms_api.get_spat_program_version(sca.person_id, sca.course_cd, p_term_cal_type,
           p_term_sequence_number)
AND   sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
AND sca.person_id = p_person_id
AND pv.course_type = p_carrer
AND  igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, p_term_cal_type,
           p_term_sequence_number) = 'PRIMARY';

Line: 1277

SELECT pv.title
FROM   IGS_EN_STDNT_PS_ATT_ALL sca,
       IGS_PS_VER_ALL pv
WHERE  pv.course_cd = sca.course_cd
AND    pv.version_number = sca.version_number
AND    sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
AND    sca.person_id = p_person_id
AND    pv.course_type = p_carrer
AND    sca.course_cd <> p_course_code;

Line: 1324

SELECT NVL(subtitle_modifiable_flag,'N')
FROM igs_ps_usec_ref
WHERE
uoo_id      = p_uoo_id;

Line: 1348

SELECT unit_cd,version_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;

Line: 1353

SELECT
       minimum_credit_points,
       maximum_credit_points,
       variable_increment
FROM igs_ps_usec_cps
WHERE uoo_id = p_uoo_id;

Line: 1361

SELECT
        POINTS_MIN             ,
        POINTS_MAX             ,
        points_increment
FROM igs_ps_unit_ver
WHERE unit_cd = p_unit_cd
AND version_number = p_unit_ver;

Line: 1370

SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
FROM
igs_ps_unit_ofr_opt uoo,
igs_ps_usec_cps cps,
igs_ps_unit_ver uv
WHERE
uoo.uoo_id = cps.uoo_id(+) AND
uoo.uoo_id=p_uoo_id  AND
uoo.unit_cd=uv.unit_cd AND
uoo.version_number = uv.version_number;

Line: 1467

  SELECT system_type
  FROM   igs_pe_person_types
  WHERE  person_type_code = p_person_type;

Line: 1501

    OPEN cur_program_steps FOR SELECT DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn) notification_flag
                               FROM   igs_en_cpd_ext  eru,
                                      igs_lookups_view lkup
                               WHERE  eru.s_enrolment_step_type    =  lkup.lookup_code           AND
                                      eru.enrolment_cat            =  p_enrollment_category      AND
                                     (eru.s_student_comm_type      =  p_comm_type      OR
                                      eru.s_student_comm_type      =  'ALL'               )      AND
                                      eru.enr_method_type          =  p_enr_method_type          AND
                                      lkup.lookup_type             =  'ENROLMENT_STEP_TYPE_EXT'  AND
                                      lkup.step_group_type         =  p_step_group_type          AND
                                      eru.s_enrolment_step_type    =  p_step_type;

Line: 1516

        OPEN cur_program_steps FOR SELECT DECODE (uact.deny_warn,
                                       'WARN', 'WARN',
                                       'DENY', 'DENY',
                                       NULL, DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn)
                                     ) notification_flag
                        FROM   igs_en_cpd_ext_all eru,
                               igs_pe_usr_aval_all uact,
                               igs_lookups_view lkup
                        WHERE  eru.s_enrolment_step_type = lkup.lookup_code
                        AND    eru.enrolment_cat = p_enrollment_category
                        AND    eru.enr_method_type = p_enr_method_type
                        AND    (eru.s_student_comm_type = p_comm_type
                               OR eru.s_student_comm_type = 'ALL')
                        AND    lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
                        AND    lkup.step_group_type = p_step_group_type
                        AND    eru.s_enrolment_step_type = uact.VALIDATION(+)
                        AND    uact.person_type(+) = p_person_type
                        AND    NVL (uact.override_ind, 'N') = 'N'
                        AND    eru.s_enrolment_step_type = p_step_type;

Line: 1555

  SELECT  TO_CHAR(UNIT_SECTION_START_DATE) ||'  -  '||
          TO_CHAR(UNIT_SECTION_END_DATE  )
  FROM    igs_ps_unit_ofr_opt
  WHERE   unit_cd        = x_unit_cd
  AND     version_number = x_version
  AND     cal_type       = x_cal_type
  AND     ci_sequence_number = x_ci_seq_number
  AND     location_cd        = x_location_cd
  AND     unit_class         = x_unit_class ;

Line: 1566

  SELECT TO_CHAR(START_DT)       || '  -  ' ||
         TO_CHAR(END_DT)
  FROM   igs_ca_inst
  WHERE  cal_type  = x_cal_type
  AND    sequence_number = x_ci_seq_number;

Line: 1596

SELECT enrollment_actual
FROM   igs_ps_unit_ofr_opt
WHERE  uoo_id=p_uooid;

Line: 1601

SELECT enrollment_minimum,enrollment_maximum
FROM   igs_ps_usec_lim_wlst_v
WHERE  uoo_id =p_uooid;

Line: 1606

SELECT enrollment_minimum,enrollment_maximum
FROM   igs_ps_unit_ver_v
WHERE  unit_cd=p_unitcode
AND    version_number=p_version;

Line: 1654

SELECT  ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
    FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
   WHERE ttl.teach_cal_type = sua.cal_type
     AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
     AND sua.unit_attempt_status = 'ENROLLED'
     AND sua.person_id = p_person_id
     AND sua.course_cd = p_course_cd
ORDER BY ttl.load_start_dt DESC;

Line: 1665

SELECT  ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
    FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
   WHERE ttl.teach_cal_type = sua.cal_type
     AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
     AND sua.unit_attempt_status = 'ENROLLED'
     AND sua.person_id = p_person_id
ORDER BY ttl.load_start_dt DESC;

Line: 1699

SELECT  first_name || ' ' || last_name  Instructor_Name
FROM igs_pe_person_base_v  a,
     igs_ps_usec_tch_resp b
WHERE b.uoo_id = p_uoo_id AND
b.INSTRUCTOR_ID = a.person_id AND
b.LEAD_INSTRUCTOR_FLAG = 'Y';

Line: 1739

CURSOR cur_org IS SELECT max_stud_per_wlst FROM  igs_en_or_unit_wlst
                                            WHERE org_unit_cd     = p_owner_org_unit_cd  AND
                                                  cal_type        = p_cal_type           AND
                                                  sequence_number = p_sequence_number;

Line: 1778

SELECT hz.person_last_name || ', '||hz.person_first_name || ' '||hz.person_middle_name instructor_name
FROM
hz_parties hz,
igs_ps_uso_instrctrs a
WHERE a.instructor_id(+) = hz.party_id
AND   a.unit_section_occurrence_id = p_uoo_id
ORDER BY 1 ;

Line: 1826

  SELECT  grp.usec_x_listed_group_name
  FROM    igs_ps_usec_x_grpmem grpmem,
          igs_ps_usec_x_grp grp
  WHERE   grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
  AND     grpmem.uoo_id = l_uoo_id;

Line: 1835

  SELECT  grp.class_meet_group_name
  FROM    igs_ps_uso_clas_meet ucm,
          igs_ps_uso_cm_grp grp
  WHERE   grp.class_meet_group_id = ucm.class_meet_group_id
  AND     ucm.uoo_id = l_uoo_id;

Line: 1843

   SELECT meaning
   FROM igs_lookups_view
   WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
   AND lookup_code = l_lookup_code;

Line: 1923

  SELECT  grp.max_enr_group, grpmem.usec_x_listed_group_id
  FROM    igs_ps_usec_x_grpmem grpmem,
          igs_ps_usec_x_grp grp
  WHERE   grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
  AND     grpmem.uoo_id = l_uoo_id;

Line: 1932

  SELECT  grp.max_enr_group, ucm.class_meet_group_id
  FROM    igs_ps_uso_clas_meet ucm,
          igs_ps_uso_cm_grp grp
  WHERE   grp.class_meet_group_id = ucm.class_meet_group_id
  AND     ucm.uoo_id = l_uoo_id;

Line: 1941

  SELECT SUM(enrollment_actual)
  FROM   igs_ps_unit_ofr_opt uoo,
         igs_ps_usec_x_grpmem ugrp
  WHERE  uoo.uoo_id = ugrp.uoo_id
  AND    ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;

Line: 1951

  SELECT SUM(enrollment_actual)
  FROM   igs_ps_unit_ofr_opt uoo,
         igs_ps_uso_clas_meet ucls
  WHERE  uoo.uoo_id = ucls.uoo_id
  AND    ucls.class_meet_group_id = l_class_meet_group_id;

Line: 1960

   SELECT meaning
   FROM igs_lookups_view
   WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
   AND lookup_code = l_lookup_code;

Line: 1967

  SELECT enrollment_maximum
  FROM igs_ps_usec_lim_wlst
  WHERE uoo_id = p_uoo_id;

Line: 1973

  SELECT enrollment_maximum
  FROM   igs_ps_unit_ver
  WHERE  (unit_cd , version_number ) IN (SELECT unit_cd , version_number
                                         FROM   igs_ps_unit_ofr_opt
                                         WHERE  uoo_id = p_uoo_id);

Line: 1983

  SELECT enrollment_actual
  FROM   igs_ps_unit_ofr_opt
  WHERE  uoo_id = cp_uoo_id;

Line: 2152

  SELECT  grp.max_enr_group, grpmem.usec_x_listed_group_id
  FROM    igs_ps_usec_x_grpmem grpmem,
          igs_ps_usec_x_grp grp
  WHERE   grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
  AND     grpmem.uoo_id = l_uoo_id;

Line: 2161

  SELECT  grp.max_enr_group, ucm.class_meet_group_id
  FROM    igs_ps_uso_clas_meet ucm,
          igs_ps_uso_cm_grp grp
  WHERE   grp.class_meet_group_id = ucm.class_meet_group_id
  AND     ucm.uoo_id = l_uoo_id;

Line: 2250

  SELECT unit_cd, unit_class
  FROM   igs_ps_unit_ofr_opt
  WHERE  uoo_id = p_uoo_id;

Line: 2258

  SELECT meaning
  FROM   igs_lookup_values lkup,  IGS_EN_SS_DISP_STPS en
  WHERE  lkup.lookup_type = 'IGS_EN_CORE_IND'
  AND    lkup.lookup_code = en.core_req_ind;

Line: 2310

  SELECT 'TRUE'
  FROM igs_en_cat_prc_step
  WHERE enrolment_cat = cp_enrolment_cat AND
  (s_student_comm_type = cp_student_comm_type OR
   s_student_comm_type = 'ALL' ) AND
  enr_method_type = cp_enr_method_type AND
  s_enrolment_step_type = cp_enrolment_step_type;

Line: 2392

    SELECT us.title
    FROM  igs_as_su_setatmpt susa ,
          igs_en_unit_set us ,
          igs_en_unit_set_cat usc
    WHERE susa.person_id =  cp_person_id
    AND   susa.course_cd = cp_program_cd
    AND   susa.student_confirmed_ind = 'Y'
    AND  cp_term_census_date
         BETWEEN susa.selection_dt
         AND   NVL(susa.rqrmnts_complete_dt,NVL(susa.end_dt, cp_term_census_date))
    AND   susa.unit_set_cd = us.unit_set_cd
    AND   us.unit_set_cat = usc.unit_set_cat
    AND   usc.s_unit_set_cat  = 'PRENRL_YR'
    ORDER BY susa.selection_dt DESC;

Line: 2409

       SELECT   NVL (absolute_val,
                  igs_ca_gen_001.calp_get_alias_val (
                  dai.dt_alias,
                  dai.sequence_number,
                  dai.cal_type,
                  dai.ci_sequence_number
                      )
        ) AS term_census_date
        FROM     igs_ge_s_gen_cal_con sgcc,
                 igs_ca_da_inst dai
        WHERE    sgcc.s_control_num = 1
        AND      dai.dt_alias = sgcc.census_dt_alias
        AND      dai.cal_type = cp_cal_type
        AND      dai.ci_sequence_number = cp_cal_seq_number
        ORDER by 1 desc;

Line: 2479

     SELECT pv.title
     FROM igs_en_stdnt_ps_att_all sca,
          igs_ps_ver_all pv
     WHERE pv.course_cd = sca.course_cd
     AND   pv.version_number = sca.version_number
     AND   sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
     AND   sca.person_id = cp_person_id
     AND   sca.course_cd = cp_program_cd
     AND   ((igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) = 'PRIMARY') OR
            (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N')= 'N')
           );

Line: 2526

    SELECT pv.title
     FROM igs_en_stdnt_ps_att_all sca,
          igs_ps_ver_all pv
     WHERE pv.course_cd = sca.course_cd
     AND pv.version_number = sca.version_number
     AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
     AND sca.person_id = cp_person_id
     AND igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) <> 'PRIMARY'
     AND pv.course_type = (SELECT course_type
                           FROM igs_ps_ver_all
                           WHERE course_cd = cp_program_cd
                           AND version_number = cp_version_number);

Line: 2577

SELECT relation_type ,sup_uoo_Id
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;

Line: 2623

  SELECT uoo_id
  FROM igs_ps_unit_ofr_opt
  WHERE sup_uoo_id = p_uoo_id;

Line: 2663

    SELECT meaning
    FROM igs_lookup_values
    WHERE lookup_code = cp_lookup_code
    AND lookup_type = 'UOO_RELATION_TYPE';

Line: 2669

    SELECT unit_cd
    FROM igs_ps_unit_ofr_opt
    WHERE uoo_id = cp_sup_uoo_id;

Line: 2718

      SELECT 1
      FROM   IGS_PS_UNT_OFR_OPT_N USEC
      WHERE  USEC.UOO_ID = cp_n_uoo_id
      AND    ROWNUM < 2 ;

Line: 2724

      SELECT 1
      FROM   IGS_PS_UNT_OFR_PAT_N UOP,
             IGS_PS_UNIT_OFR_OPT_ALL UOO
      WHERE  UOO.UNIT_CD = UOP.UNIT_CD
        AND  UOO.VERSION_NUMBER = UOP.VERSION_NUMBER
        AND  UOO.CAL_TYPE = UOP.CAL_TYPE
        AND  UOO.CI_SEQUENCE_NUMBER = UOP.CI_SEQUENCE_NUMBER
        AND  UOO.UOO_ID = cp_n_uoo_id
        AND  ROWNUM < 2;

Line: 2735

      SELECT 1
      FROM   IGS_PS_UNIT_OFR_NOTE UO,
             IGS_PS_UNIT_OFR_OPT_ALL UOO
      WHERE  UOO.UNIT_CD = UO.UNIT_CD
        AND  UOO.VERSION_NUMBER = UO.VERSION_NUMBER
        AND  UOO.CAL_TYPE = UO.CAL_TYPE
        AND  UOO.UOO_ID = cp_n_uoo_id
        AND  ROWNUM < 2;

Line: 2745

      SELECT 1
      FROM   IGS_PS_UNIT_VER_NOTE UV,
             IGS_PS_UNIT_OFR_OPT_ALL UOO
      WHERE  UOO.UNIT_CD = UV.UNIT_CD
        AND  UOO.VERSION_NUMBER = UV.VERSION_NUMBER
        AND  UOO.UOO_ID = cp_n_uoo_id
        AND  ROWNUM < 2;

Line: 2791

FUNCTION GET_DUP_SUA_SELECTION (
    p_person_id IN NUMBER,
    p_src_course_cd IN VARCHAR2,
    p_dest_course_cd IN VARCHAR2,
    p_uoo_id IN NUMBER
    )  RETURN VARCHAR2 AS
  ------------------------------------------------------------------
  --Created by  : Satya Vanukuri, Oracle IDC
  --Date created: 23-Dec-2004
  --
  --Purpose: This Function returns 'Y' if a duplicate unit attempt
  --in the source program can be unchecked in the Program Transfer Page.
  --
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --Somasekar   17th feb 2006	Bug # 5026874
  -------------------------------------------------------------------
-- Get the details of
Cursor uoo_attempt_status (
     cp_person_id IN NUMBER ,
     cp_course_cd IN VARCHAR2,
     cp_uoo_id NUMBER) IS
SELECT unit_attempt_status
FROM igs_en_su_Attempt
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND uoo_id = cp_uoo_id;

Line: 2862

END get_dup_sua_selection;

Line: 2867

   Select title from igs_ps_unit_ver
    where unit_cd=cp_unit_cd
    and version_number=cp_version;

Line: 2888

    select max_students_per_waitlist
    from igs_ps_usec_lim_wlst
    where uoo_id=cp_uoo_id;

Line: 2894

   select max_students_per_waitlist
   from igs_ps_unit_ofr_pat
   where unit_cd=cp_unit_cd
        and version_number=cp_version
        and cal_type=cp_cal_type
        and ci_sequence_number=cp_sequence_number
        and delete_flag = 'N';

Line: 2932

    select enrollment_maximum
    from igs_ps_usec_lim_wlst
    where uoo_id=cp_uooid;

Line: 2938

    select enrollment_maximum
    from igs_ps_unit_ver
    where unit_cd=cp_unit_cd
    and version_number=cp_version;

Line: 2966

    select enrollment_minimum
    from igs_ps_usec_lim_wlst
    where uoo_id=cp_uooid;

Line: 2972

    select enrollment_minimum
    from igs_ps_unit_ver
    where unit_cd=cp_unit_cd
    and version_number=cp_version;

Line: 3018

       SELECT alias_val
       FROM   igs_ca_da_inst_v
       WHERE  cal_type = cp_c_cal_type
       AND    ci_sequence_number = cp_n_seq_num
       AND    dt_alias = cp_c_dt_alias
       ORDER BY alias_val DESC;

Line: 3074

             SELECT tr.start_dt_time,
                    tr.end_dt_time
             FROM   igs_en_timeslot_rslt tr,
                    igs_en_timeslot_para tp
             WHERE  tr.person_id = p_n_person_id
             AND    tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
             AND    tp.cal_type = cp_cal_type
             AND    tp.sequence_number = cp_sequence_number;

Line: 3199

        SELECT pe.last_name || ', ' || pe.first_name || ' ' || pe.middle_name name
        FROM igs_ps_uso_instrctrs instr,
             igs_pe_person_base_v pe
        WHERE instr.unit_section_occurrence_id = cp_n_occurs_id AND
              instr.instructor_id = pe.person_id;

Line: 3242

     SELECT
            TO_CHAR(NVL(NVL(USO.START_DATE,US.UNIT_SECTION_START_DATE),CA.START_DT),'DD MON YYYY') || ' - ' ||
            TO_CHAR(NVL(NVL(USO.END_DATE,US.UNIT_SECTION_END_DATE),CA.END_DT),'DD MON YYYY') effective_date,
            uso.building_code,
            uso.room_code,
            uso.to_be_announced,
            uso.no_set_day_ind,
            NVL(
              DECODE(uso.monday,  'Y',  'M',  NULL)    ||
            DECODE(uso.tuesday,  'Y',  'Tu',  NULL)  ||
            DECODE(uso.wednesday,  'Y',  'W',  NULL) ||
            DECODE(uso.thursday,  'Y',  'Th',  NULL) ||
            DECODE(uso.friday,  'Y',  'F',  NULL)    ||
            DECODE(uso.saturday,  'Y',  'Sa',  NULL) ||
              DECODE(uso.sunday,  'Y',  'Su',  NULL),'TBA') meetings,
            TO_CHAR(uso.start_time,'hh:miam') start_time,
            TO_CHAR(uso.end_time, 'hh:miam') end_time
     FROM   igs_ps_usec_occurs_all USO,
            igs_ps_unit_ofr_opt_all US,
            igs_ca_inst_all CA
     WHERE  uso.uoo_id = cp_n_uoo_id AND
            uso.uoo_id = us.uoo_id AND
            us.cal_type = ca.cal_type AND
            us.ci_sequence_number = ca.sequence_number
     ORDER BY uso.unit_section_occurrence_id;

Line: 3273

        SELECT building_cd
        FROM   igs_ad_building_all
        WHERE  building_id = cp_n_building_id;

Line: 3287

        SELECT room_cd
        FROM   igs_ad_room_all
        WHERE  room_id = cp_n_room_id;

Line: 3303

        SELECT NVL(us.unit_section_start_date,ca.start_dt) start_date,
               NVL(us.unit_section_end_date, ca.end_dt) end_date
        FROM igs_ps_unit_ofr_opt_all us,
             igs_ca_inst_all ca
        WHERE us.uoo_id = cp_n_uoo_id AND
              us.cal_type = ca.cal_type AND
              us.ci_sequence_number = ca.sequence_number;

Line: 3360

      SELECT unit_section_occurrence_id
      FROM igs_ps_usec_occurs_all
      WHERE uoo_id = cp_n_uoo_id
      ORDER BY unit_section_occurrence_id;

Line: 3365

      SELECT pe.last_name || ', ' || pe.first_name || ' ' || pe.middle_name name
      FROM igs_ps_uso_instrctrs instr,
           igs_pe_person_base_v pe
      WHERE instr.unit_section_occurrence_id = cp_n_occurs_id AND
            instr.uso_instructor_id = pe.person_id;

Line: 3391

      SELECT t.title
      FROM   igs_ps_usec_ref t
      WHERE  t.uoo_id = cp_n_uoo_id;

Line: 3396

       SELECT uv.title
       FROM   igs_ps_unit_ofr_opt_all us,
              igs_ps_unit_ver_all uv
       WHERE  us.uoo_id = cp_n_uoo_id
       AND    us.unit_cd = uv.unit_cd
       AND    us.version_number = uv.version_number;

Line: 3436

      SELECT rul_sequence_number
      FROM   igs_ps_usec_ru
      WHERE  uoo_id = p_n_uoo_id
      AND    s_rule_call_cd = cp_c_rul_call_cd;

Line: 3443

      SELECT ru.rul_sequence_number
      FROM   igs_ps_unit_ver_ru ru,
             igs_ps_unit_ofr_opt_all uoo
      WHERE  uoo.uoo_id = p_n_uoo_id
      AND    uoo.unit_cd = ru.unit_cd
      AND    uoo.version_number = ru.version_number
      AND    ru.s_rule_call_cd = cp_c_rul_call_cd;

Line: 3503

  SELECT unit_cd,version_number,cal_type,ci_sequence_number
  FROM  igs_ps_unit_ofr_opt uoo
  WHERE uoo_id = cp_uoo_id;

Line: 3589

     SELECT rul_sequence_number
     FROM igs_ps_usec_ru
     WHERE uoo_id = p_uoo_id
     AND s_rule_call_cd = 'USEC'|| p_rule_type;

Line: 3597

     SELECT rul_sequence_number
     FROM igs_ps_unit_ver_ru uvr,
          igs_ps_unit_ofr_opt uoo
     WHERE uvr.unit_cd = uoo.unit_cd
     AND uvr.version_number = uoo.version_number
     AND   uoo_id = p_uoo_id
     AND uvr.s_rule_call_cd = p_rule_type;

Line: 3633

      SELECT meaning
      FROM   igs_lookup_values
      WHERE  lookup_type = cp_c_lkup_type
      AND    lookup_code = cp_c_lkup_code;

Line: 3669

      SELECT NVL(usec.special_permission_ind,'N')  special_permission_ind
                         FROM igs_ps_unit_ofr_opt_all usec
      WHERE usec.uoo_id = cp_uoo_id;

Line: 3711

      SELECT     NVL(usec.auditable_ind,'N')  auditable_ind,
      NVL(usec.audit_permission_ind,'N')  audit_permission_ind
      FROM igs_ps_unit_ofr_opt_all usec
      WHERE usec.uoo_id = cp_uoo_id;

Line: 3755

      SELECT NVL(special_permission_ind,'N'),NVL(audit_permission_ind,'N')
      FROM igs_ps_unit_ofr_opt
      WHERE uoo_id=cp_uoo_id;

Line: 3805

    Select NVL(usec.auditable_ind,'N') auditable_ind, cal_type,ci_sequence_number
    FROM igs_ps_unit_ofr_opt_all usec
    WHERE  usec.uoo_id = cp_uoo_id;

Line: 3810

     SELECT UPD_AUDIT_DT_ALIAS
     FROM   igs_pe_usr_arg
     WHERE  person_type = cp_person_type;

Line: 3815

     SELECT AUDIT_STATUS_DT_ALIAS
     FROM   igs_en_cal_conf
     WHERE  s_control_num = 1;

Line: 3882

    Select practical_ind
    From igs_ps_unit_ver
    where unit_cd=cp_unit_cd
    and version_number= cp_version_number;

Line: 3918

  SELECT  grp.max_enr_group, grpmem.usec_x_listed_group_id
  FROM    igs_ps_usec_x_grpmem grpmem,
          igs_ps_usec_x_grp grp
  WHERE   grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
  AND     grpmem.uoo_id = l_uoo_id;

Line: 3927

  SELECT  grp.max_enr_group, ucm.class_meet_group_id
  FROM    igs_ps_uso_clas_meet ucm,
          igs_ps_uso_cm_grp grp
  WHERE   grp.class_meet_group_id = ucm.class_meet_group_id
  AND     ucm.uoo_id = l_uoo_id;

Line: 3936

  SELECT SUM(enrollment_actual)
  FROM   igs_ps_unit_ofr_opt uoo,
         igs_ps_usec_x_grpmem ugrp
  WHERE  uoo.uoo_id = ugrp.uoo_id
  AND    ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;

Line: 3946

  SELECT SUM(enrollment_actual)
  FROM   igs_ps_unit_ofr_opt uoo,
         igs_ps_uso_clas_meet ucls
  WHERE  uoo.uoo_id = ucls.uoo_id
  AND    ucls.class_meet_group_id = l_class_meet_group_id;

Line: 3955

  SELECT enrollment_maximum
  FROM igs_ps_usec_lim_wlst
  WHERE uoo_id = p_uoo_id;

Line: 3961

  SELECT enrollment_maximum
  FROM   igs_ps_unit_ver
  WHERE  (unit_cd , version_number ) IN (SELECT unit_cd , version_number
                                         FROM   igs_ps_unit_ofr_opt
                                         WHERE  uoo_id = p_uoo_id);

Line: 3971

  SELECT enrollment_actual
  FROM   igs_ps_unit_ofr_opt
  WHERE  uoo_id = cp_uoo_id;

Line: 4108

    SELECT cal_type, ci_sequence_number
    FROM IGS_PS_UNIT_OFR_OPT
    WHERE uoo_id = cp_uoo_id;

Line: 4114

       SELECT 1
       FROM   igs_ps_unit_ofr_opt_all
       WHERE  sup_uoo_id = cp_n_uoo_id
       AND    rownum <2;

Line: 4124

      SELECT 1
      FROM   IGS_EN_SU_ATTEMPT_ALL sua,
                    IGS_PS_UNIT_OFR_OPT_ALL uoo
      WHERE  sua.uoo_id = uoo.uoo_id
      AND    uoo.sup_uoo_id = cp_n_uoo_id
      AND    sua.course_cd = cp_c_course_cd
      AND    sua.person_id = cp_n_person_id
      AND    sua.unit_attempt_status NOT IN ('ENROLLED','INVALID','DISCONTIN','DROPPED')
      AND    ROWNUM <2;

Line: 4138

      SELECT sua.uoo_id,
             sua.core_indicator_code
      FROM   IGS_EN_SU_ATTEMPT_ALL sua,
                    IGS_PS_UNIT_OFR_OPT_ALL uoo
      WHERE  sua.uoo_id = uoo.uoo_id
      AND    uoo.sup_uoo_id = cp_n_uoo_id
      AND    sua.course_cd = cp_c_course_cd
      AND    sua.person_id = cp_n_person_id
      AND    sua.unit_attempt_status IN ('ENROLLED','INVALID');

Line: 4202

           RETURN 'N';  -- Can be selected for swap

Line: 4230

SELECT  SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
             cp_term_cal_type,cp_term_seq_num)) apor_cp
FROM IGS_EN_PLAN_UNITS pls
WHERE pls.cart_error_flag= 'N'
AND  pls.person_id = p_personid
AND  pls.course_cd = p_course_cd
AND  pls.term_cal_type = cp_term_cal_type
AND  pls.term_ci_sequence_number = cp_term_seq_num;

Line: 4240

SELECT   SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
             cp_term_cal_type,cp_term_seq_num)) apor_cp
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.unit_attempt_status = 'UNCONFIRM'
   AND sua.person_id = p_personid
  AND  sua.course_cd = p_course_cd
  AND  (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where
                                                        load_cal_type = cp_term_cal_type and load_ci_sequence_number = cp_term_seq_num);

Line: 4299

SELECT   ci.schedule_flag schedule_flag
FROM igs_ca_inst_all ci
WHERE CAL_TYPE = p_load_calendar_type
AND   SEQUENCE_NUMBER = p_load_cal_sequence_number;

Line: 4306

SELECT  schedule_open_dt_alias
FROM   igs_en_cal_conf
WHERE  s_control_num = 1;

Line: 4353

FUNCTION  is_selection_enabled (p_person_id                  IN  NUMBER,
                                p_load_cal_type              IN  VARCHAR2,
                                p_load_seq_num               IN  NUMBER,
                                p_person_type                IN VARCHAR2,
                                p_message                    OUT NOCOPY  VARCHAR2
                                ) RETURN VARCHAR2
------------------------------------------------------------------
  --Created by  : rvangala
  --Date created: 24-May-2005
  --
  --Purpose: Function checks if unit sections can be selected to be enrolled
  --         for a term
  --
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --ckasu    29-Jul-2005      modified as a part of EN 317 Build
  --svanukur   30-sep-2005   modified as a part of EN 317 Build

-------------------------------------------------------------------
IS
 --cursor to check if the selected load calendar is open only for searching
 --but not for planning or  for the schedule.
 CURSOR c_get_load_cal_open_status(cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
    SELECT  'x'
    FROM  IGS_CA_INST
    WHERE CAL_TYPE = cp_load_cal_type
    AND   SEQUENCE_NUMBER = cp_load_seq_num
    AND   SS_DISPLAYED = 'Y'
    AND   PLANNING_FLAG = 'N'
    AND   SCHEDULE_FLAG = 'N';

Line: 4389

    SELECT distinct cir.sub_cal_type ,cir.sub_ci_sequence_number
    FROM igs_en_stdnt_ps_att sca,
         igs_ca_inst_rel cir,
         igs_ca_type ct
    WHERE cir.sup_cal_type = sca.cal_type and
          ct.cal_type = cir.sub_cal_type  and
          ct.s_cal_cat = 'LOAD' and
          sca.person_id = cp_person_id and
          cir.sub_cal_type = cp_load_cal_type and
          cir.sub_ci_sequence_number = cp_load_seq_num;

Line: 4401

    SELECT system_type
    FROM igs_pe_person_types
    WHERE person_type_code = p_person_type_code;

Line: 4442

 END is_selection_enabled;

Line: 4458

       SELECT t.subtitle
       FROM   igs_ps_unit_subtitle t,
                      igs_ps_usec_ref us
       WHERE  us.uoo_id = cp_n_uoo_id
      AND    us.subtitle_id = t.subtitle_id;

Line: 4465

       SELECT t.subtitle
       FROM   igs_ps_unit_subtitle t,
                      igs_ps_unit_ofr_opt_all us,
                      igs_ps_unit_ver_all uv
       WHERE  us.uoo_id = cp_n_uoo_id
       AND    us.unit_cd = uv.unit_cd
       AND    us.version_number = uv.version_number
       AND    uv.subtitle_id = t.subtitle_id;

Line: 4505

      Select NVL(waitlist_actual,0)
      from igs_ps_unit_ofr_opt
      where uoo_id=cp_uoo_id;

Line: 4540

       SELECT uso.to_be_announced,
                       uso.no_set_day_ind,
                       DECODE(uso.monday,  'Y',  'M',  NULL)   ||
                       DECODE(uso.tuesday,  'Y',  'Tu',  NULL)  ||
                       DECODE(uso.wednesday,  'Y',  'W',  NULL) ||
                       DECODE(uso.thursday,  'Y',  'Th',  NULL) ||
                       DECODE(uso.friday,  'Y',  'F',  NULL)    ||
                       DECODE(uso.saturday,  'Y',  'Sa',  NULL) ||
                       DECODE(uso.sunday,  'Y',  'Su',  NULL)  meetings
      FROM    igs_ps_usec_occurs_all uso
      WHERE   uso.unit_section_occurrence_id = cp_n_uso_id;

Line: 4583

       SELECT uso.no_set_day_ind,
              to_char(uso.start_time,'hh:miam') start_time,
              to_char(uso.end_time,'hh:miam') end_time
       FROM    igs_ps_usec_occurs_all uso
       WHERE   uso.unit_section_occurrence_id = cp_n_uso_id;

Line: 4622

      SELECT           TO_CHAR( NVL( NVL( USO.START_DATE, US.UNIT_SECTION_START_DATE),
                                CA.START_DT), 'DD MON YYYY') || ' - ' ||
                                TO_CHAR( NVL( NVL( USO.END_DATE, US.UNIT_SECTION_END_DATE),
                                CA.END_DT), 'DD MON YYYY')  effective_date
     FROM   igs_ps_usec_occurs_all USO,
                    igs_ps_unit_ofr_opt_all US,
                    igs_ca_inst_all CA
     WHERE  uso.unit_section_occurrence_id = cp_n_uso_id
    AND        uso.uoo_id = us.uoo_id
    AND        us.cal_type = ca.cal_type
    AND        us.ci_sequence_number = ca.sequence_number;

Line: 4668

     SELECT  planning_flag,
             schedule_flag
     FROM igs_ca_inst_all ci
     WHERE CAL_TYPE = cp_load_cal_type
     AND   SEQUENCE_NUMBER = cp_load_seq_num;

Line: 4675

             SELECT planning_open_dt_alias, schedule_open_dt_alias
             FROM   igs_en_cal_conf
             WHERE  s_control_num = 1;

Line: 4683

     SELECT plan_sht_status
     FROM   igs_en_spa_terms
     WHERE  person_id= cp_person_id
     AND    program_cd=cp_course_cd
     AND    term_cal_type=cp_load_cal_type
     AND    term_sequence_number=cp_load_seq_num;

Line: 4691

     SELECT system_type
     FROM igs_pe_person_types
     WHERE person_type_code = p_person_type_code;

Line: 4886

SELECT DISTINCT unit_cd
FROM igs_ps_unit
WHERE unit_cd like cp_unit_cd;

Line: 4942

      SELECT rul_sequence_number
      FROM igs_ps_usec_ru
      WHERE uoo_id = cp_uoo_id
      AND s_rule_call_cd = 'USECCOREQ';

Line: 4949

     SELECT rul_sequence_number
     FROM igs_ps_unit_ver_ru uvr, igs_ps_unit_ofr_opt uoo
     WHERE uvr.unit_cd = uoo.unit_cd
     AND uvr.version_number = uoo.version_number
     AND uoo_id = cp_uoo_id
     AND uvr.s_rule_call_cd = 'COREQ';

Line: 5051

      SELECT unit_section_reference_id
      FROM igs_ps_usec_ref
      WHERE uoo_id = cp_n_uoo_id;

Line: 5057

      SELECT 1
      FROM igs_ps_usec_ref_cd
      WHERE unit_section_reference_id =cp_n_ref_id
       AND   ROWNUM <2;

Line: 5063

      SELECT 1
      FROM igs_ps_us_req_ref_cd
      WHERE unit_section_reference_id =cp_n_ref_id
       AND   ROWNUM <2;

Line: 5069

      SELECT unit_cd,
                      version_number
      FROM   igs_ps_unit_ofr_opt_all
      WHERE  uoo_id = cp_n_uoo_id;

Line: 5076

      SELECT 1
      FROM   igs_ps_unit_ref_cd
      WHERE  unit_cd = cp_c_unit_cd
      AND       version_number = cp_n_version
      AND       ROWNUM < 2;

Line: 5083

      SELECT 1
      FROM   igs_ps_unitreqref_cd
      WHERE  unit_cd = cp_c_unit_cd
      AND        version_number = cp_n_version
      AND        ROWNUM <2 ;

Line: 5220

  SELECT unit_cd, unit_class, CORE_INDICATOR_CODE
  FROM   igs_en_su_attempt
  WHERE   person_id = p_person_id
      AND course_cd = p_program_cd
      AND    uoo_id = p_uoo_id;

Line: 5230

  SELECT meaning
  FROM   igs_lookup_values lkup,  IGS_EN_SS_DISP_STPS en
  WHERE  lkup.lookup_type = 'IGS_EN_CORE_IND'
  AND    lkup.lookup_code = en.core_req_ind;

Line: 5278

    SELECT  SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
                 cp_term_cal_type,cp_term_seq_num)) apor_cp
    FROM IGS_EN_PLAN_UNITS pls
    WHERE pls.cart_error_flag= 'Y'
    AND  pls.person_id = p_personid
    AND  pls.course_cd = p_course_cd
    AND  pls.term_cal_type = cp_term_cal_type
    AND  pls.term_ci_sequence_number = cp_term_seq_num;

Line: 5289

    SELECT   SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
                 cp_term_cal_type,cp_term_seq_num)) apor_cp
    FROM IGS_EN_SU_ATTEMPT sua
    WHERE sua.unit_attempt_status = 'UNCONFIRM'
    AND sua.person_id = p_personid
    AND  sua.course_cd = p_course_cd
    AND  (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where
                                                        load_cal_type = cp_term_cal_type and load_ci_sequence_number = cp_term_seq_num)
    AND ss_source_ind <> 'S';

Line: 5338

       SELECT   NVL (absolute_val,
                  igs_ca_gen_001.calp_get_alias_val (
                  dai.dt_alias,
                  dai.sequence_number,
                  dai.cal_type,
                  dai.ci_sequence_number
                      )
        ) AS term_census_date
        FROM     igs_ge_s_gen_cal_con sgcc,
                 igs_ca_da_inst dai
        WHERE    sgcc.s_control_num = 1
        AND      dai.dt_alias = sgcc.census_dt_alias
        AND      dai.cal_type = cp_cal_type
        AND      dai.ci_sequence_number = cp_cal_seq_number
        ORDER by 1 desc;

Line: 5360

       SELECT NVL(susa.override_title, us.title) title,
              NVL(susa.rqrmnts_complete_dt,NVL(susa.end_dt, cp_term_census_date)) end_date
       FROM  igs_as_su_setatmpt susa ,
             igs_en_unit_set us ,
             igs_en_unit_set_cat usc
       WHERE susa.person_id =  cp_person_id
       AND   susa.course_cd = cp_program_cd
       AND   susa.student_confirmed_ind = 'Y'
       AND  cp_term_census_date
            BETWEEN susa.selection_dt
            AND   NVL(susa.rqrmnts_complete_dt,NVL(susa.end_dt, cp_term_census_date))
       AND   susa.unit_set_cd = us.unit_set_cd
       AND   us.unit_set_cat = usc.unit_set_cat
       AND   usc.s_unit_set_cat  <> 'PRENRL_YR'
       AND   susa.unit_set_cd = cp_unit_set
       AND   susa.us_version_number = cp_version
       ORDER BY end_date, susa.selection_dt DESC;

Line: 5379

       SELECT  DISTINCT susa.unit_set_cd, susa.us_version_number
       FROM    igs_as_su_setatmpt susa
       WHERE   susa.person_id =  cp_person_id
       AND   susa.course_cd = cp_program_cd
       AND   susa.student_confirmed_ind = 'Y';

Line: 5441

    SELECT meaning
    FROM igs_lookup_values
    WHERE lookup_code = cp_lookup_code
    AND lookup_type = 'UOO_RELATION_TYPE';

Line: 5447

    SELECT unit_cd
    FROM igs_ps_unit_ofr_opt
    WHERE uoo_id = cp_sup_uoo_id;

Line: 5538

    SELECT  count(uoo_id)
    FROM IGS_EN_PLAN_UNITS pls
    WHERE pls.cart_error_flag= 'Y'
    AND  pls.person_id = p_personid
    AND  pls.course_cd = p_course_cd
    AND  pls.term_cal_type = cp_term_cal_type
    AND  pls.term_ci_sequence_number = cp_term_seq_num;

Line: 5548

    SELECT count(uoo_id)
    FROM   IGS_EN_SU_ATTEMPT sua
    WHERE  sua.unit_attempt_status = 'UNCONFIRM'
    AND    sua.person_id = p_personid
    AND    sua.course_cd = p_course_cd
    AND    sua.ss_source_ind <> 'S'
    AND    (sua.cal_type , sua.ci_sequence_number) in (SELECT teach_cal_type, teach_ci_sequence_number
                                                       FROM   igs_ca_teach_to_load_v
                                                       WHERE  load_cal_type = cp_term_cal_type
                                                       AND    load_ci_sequence_number = cp_term_seq_num);