APPS.IGS_EN_VAL_PEE dependencies on IGS_EN_ENCMB_EFCTTYP_V

Line 429: FROM IGS_EN_ENCMB_EFCTTYP_V

425: DECLARE
426: v_check VARCHAR2(1);
427: CURSOR c_seet_exist IS
428: SELECT 'x'
429: FROM IGS_EN_ENCMB_EFCTTYP_V
430: WHERE S_ENCMB_EFFECT_TYPE = p_effect_type AND
431: apply_to_course_ind = 'Y';
432: CURSOR c_sca_exist IS
433: SELECT 'x'

Line 486: FROM IGS_EN_ENCMB_EFCTTYP_V

482: DECLARE
483: v_check VARCHAR2(1);
484: CURSOR c_seet IS
485: SELECT 'x'
486: FROM IGS_EN_ENCMB_EFCTTYP_V
487: WHERE s_encmb_effect_type = p_effect_type AND
488: apply_to_course_ind = 'Y';
489: BEGIN
490: -- course code is only specified and must be for encumbrance effect types