APPS.IGS_EN_PRC_LOAD dependencies on IGS_SS_ENR_DETAILS
Line 2613: SELECT NVL(SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,ca.load_cal_type,ca.load_ci_sequence_number)),0) apor_cp
2609: CURSOR c_total_swap_credits ( cp_n_perosn_id IN NUMBER,
2610: cp_c_program IN VARCHAR2,
2611: cp_c_load_cal IN VARCHAR2,
2612: cp_n_load_seq_num IN NUMBER) IS 2613: SELECT NVL(SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,ca.load_cal_type,ca.load_ci_sequence_number)),0) apor_cp 2614: FROM IGS_EN_SU_ATTEMPT sua,
2615: IGS_CA_TEACH_TO_LOAD_V ca
2616: WHERE sua.unit_attempt_status = 'UNCONFIRM'
2617: AND sua.person_id = cp_n_perosn_id