APPS.IGS_PS_FAC_CREDT_WRKLOAD SQL Statements

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

Line: 39

  SELECT     pe.last_name  || ',  ' || pe.title  || '  ' || NVL(pe.known_as,pe.first_name) instructor_name
  FROM   igs_ps_usec_tch_resp utr,
         igs_pe_person_base_v pe,
         igs_pe_person_id_typ ppi,
         igs_pe_alt_pers_id pit
  WHERE  utr.instructor_id = pe.person_id AND
         utr.uoo_id = p_uoo_id  AND
         pe.person_id = pit.pe_person_id (+) AND
         pit.person_id_type = ppi.person_id_type AND
         ppi.preferred_ind  = 'Y' AND
         utr.lead_instructor_flag = 'Y';

Line: 82

    SELECT   DISTINCT (uoo_id) uoo_id
    FROM     igs_ps_usec_tch_resp utr
    WHERE    instructor_id = cp_instructor_id;

Line: 87

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

Line: 128

    SELECT   SUM(instructional_load) total_work_load
    FROM     igs_ps_usec_tch_resp utr
    WHERE    utr.confirmed_flag='Y'
    AND      utr.instructor_id = cp_instructor_id;

Line: 158

    SELECT   SUM(instructional_load_lab) total_work_load_lab
    FROM     igs_ps_usec_tch_resp utr
    WHERE    utr.confirmed_flag='Y'
    AND      utr.instructor_id = cp_instructor_id;

Line: 189

    SELECT   SUM(instructional_load_lecture) total_work_load_lecture
    FROM     igs_ps_usec_tch_resp utr
    WHERE    utr.confirmed_flag='Y'
    AND      utr.instructor_id = cp_instructor_id;

Line: 226

  SELECT work_load_cp_lecture,
  	 work_load_cp_lab,
  	 work_load_other
  FROM   igs_ps_usec_cps uscp
  WHERE  uscp.uoo_id = p_uoo_id;

Line: 233

  SELECT work_load_cp_lecture,
  	 work_load_cp_lab,
  	 work_load_other
  FROM   igs_ps_unit_ver_all unit,
         igs_ps_unit_ofr_opt_all usec
  WHERE  unit.unit_cd = usec.unit_cd
  AND    unit.version_number = usec.version_number
  AND    usec.uoo_id = cp_n_uoo_id;

Line: 289

  SELECT NVL(work_load_cp_lecture,-999),
  	 NVL(work_load_cp_lab,-999),
  	 NVL(work_load_other,-999)
  FROM   igs_ps_usec_cps uscp
  WHERE  uscp.uoo_id = cp_n_uoo_id;

Line: 297

  SELECT NVL(work_load_cp_lecture,-999),
  	 NVL(work_load_cp_lab,-999),
  	 NVL(work_load_other,-999)
  FROM   igs_ps_unit_ver_all unit,
         igs_ps_unit_ofr_opt_all usec
  WHERE  unit.unit_cd = usec.unit_cd
  AND    unit.version_number = usec.version_number
  AND    usec.uoo_id = cp_n_uoo_id;

Line: 308

    SELECT NVL(SUM (instructional_load_lecture),-999) lecture_workload,
           NVL(SUM (instructional_load_lab),-999) laboratory_workload,
	   NVL(SUM (instructional_load),-999) other_workload
    FROM   igs_ps_usec_tch_resp
    WHERE  uoo_id = cp_n_uoo_id
    AND    confirmed_flag = 'Y';

Line: 368

    SELECT workload_val_code
    FROM   igs_ps_unit_ver_all
    WHERE  unit_cd = cp_c_unit_cd
    AND    version_number = cp_n_version_num
    AND    ovrd_wkld_val_flag = 'Y'
    AND    ROWNUM <2;