APPS.IGS_EN_VAL_ECPD SQL Statements

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

Line: 17

    		SELECT	ecpd.enrolment_cat
    		FROM	IGS_EN_CAT_PRC_DTL	ecpd
    		WHERE	ecpd.enrolment_cat = p_enrolment_cat AND
    			ecpd.enr_method_type = p_enr_method_type AND
    			ecpd.s_student_comm_type = 'ALL';

Line: 23

    		SELECT	ecpd.enrolment_cat
    		FROM	IGS_EN_CAT_PRC_DTL	ecpd
    		WHERE	ecpd.enrolment_cat = p_enrolment_cat AND
    			ecpd.enr_method_type = p_enr_method_type AND
    			ecpd.s_student_comm_type in ('NEW','RETURN');

Line: 76

  		SELECT	closed_ind
  		FROM	IGS_EN_METHOD_TYPE
  		WHERE	enr_method_type = cp_enr_method_type;