APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_PLAN_UNITS

Line 4232: FROM IGS_EN_PLAN_UNITS pls

4228:
4229: CURSOR c_total_plan_credits(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
4230: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
4231: cp_term_cal_type,cp_term_seq_num)) apor_cp
4232: FROM IGS_EN_PLAN_UNITS pls
4233: WHERE pls.cart_error_flag= 'N'
4234: AND pls.person_id = p_personid
4235: AND pls.course_cd = p_course_cd
4236: AND pls.term_cal_type = cp_term_cal_type

Line 5280: FROM IGS_EN_PLAN_UNITS pls

5276: --cursor to fetch the total credits from planning sheet unit attempts with cart_error_flag=Y
5277: CURSOR c_total_cart_credits(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5278: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
5279: cp_term_cal_type,cp_term_seq_num)) apor_cp
5280: FROM IGS_EN_PLAN_UNITS pls
5281: WHERE pls.cart_error_flag= 'Y'
5282: AND pls.person_id = p_personid
5283: AND pls.course_cd = p_course_cd
5284: AND pls.term_cal_type = cp_term_cal_type

Line 5539: FROM IGS_EN_PLAN_UNITS pls

5535: AS
5536: --cursor to fetch the total planning sheet unit attempts with cart_error_flag=Y
5537: CURSOR c_total_cart_units(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5538: SELECT count(uoo_id)
5539: FROM IGS_EN_PLAN_UNITS pls
5540: WHERE pls.cart_error_flag= 'Y'
5541: AND pls.person_id = p_personid
5542: AND pls.course_cd = p_course_cd
5543: AND pls.term_cal_type = cp_term_cal_type