APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_USEC_CPS

Line 4185: igs_ps_usec_cps cps,

4181: igs_ps_tch_resp b,
4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt
4187: WHERE a.course_cd = p_course_cd
4188: AND a.person_id = p_person_id
4189: AND b.unit_cd = a.unit_cd

Line 4207: igs_ps_usec_cps cps,

4203: CURSOR c_total_cp IS
4204: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points))) Total_credit_points
4205: FROM igs_en_su_attempt a,
4206: igs_ps_unit_ver e,
4207: igs_ps_usec_cps cps,
4208: igs_he_st_unt_vs_all hunt
4209: WHERE a.course_cd = p_course_cd
4210: AND a.person_id = p_person_id
4211: AND a.unit_cd = hunt.unit_cd (+)

Line 4400: igs_ps_usec_cps cps,

4396: CURSOR c_cp IS
4397: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,b.enrolled_credit_points)) ) credit_points, b.unit_level
4398: FROM igs_en_su_attempt a ,
4399: igs_ps_unit_ver b,
4400: igs_ps_usec_cps cps,
4401: igs_he_st_unt_vs_all hunt
4402: WHERE a.course_cd = p_course_cd
4403: AND a.person_id = p_person_id
4404: AND a.unit_cd = b.unit_cd

Line 6136: igs_ps_usec_cps cps

6132: FROM igs_en_su_attempt_all a,
6133: igs_ps_unit_ver_all b,
6134: igs_he_st_spa_all c,
6135: igs_he_st_unt_vs_all d,
6136: igs_ps_usec_cps cps
6137: WHERE a.unit_cd = b.unit_cd
6138: AND a.version_number = b.version_number
6139: AND c.person_id = a.person_id
6140: AND c.course_cd = a.course_cd

Line 6159: igs_ps_usec_cps cps

6155: igs_ps_unit_ver_all b,
6156: igs_he_st_spa_all c,
6157: igs_he_st_unt_vs_all d,
6158: igs_as_su_stmptout e,
6159: igs_ps_usec_cps cps
6160: WHERE a.unit_cd = b.unit_cd
6161: AND a.version_number = b.version_number
6162: AND c.person_id = a.person_id
6163: AND c.course_cd = a.course_cd