DBA Data[Home] [Help]

APPS.IGS_EN_PRC_LOAD dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 2615: IGS_CA_TEACH_TO_LOAD_V ca

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
2618: AND sua.course_cd = cp_c_program
2619: AND sua.ss_source_ind = 'S'