1391: v_dummy VARCHAR2(1);
1392: CURSOR c_pot_etde IS
1393: SELECT 'X'
1394: FROM IGS_PR_OU_TYPE pot,
1395: IGS_FI_ENC_DFLT_EFT etde
1396: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1397: pot.encumbrance_type = etde.encumbrance_type AND
1398: etde.s_encmb_effect_type = cst_rstr_at_ty;
1399: BEGIN
1451: v_dummy VARCHAR2(1);
1452: CURSOR c_pot_etde IS
1453: SELECT 'X'
1454: FROM IGS_PR_OU_TYPE pot,
1455: IGS_FI_ENC_DFLT_EFT etde
1456: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1457: pot.encumbrance_type = etde.encumbrance_type AND
1458: etde.s_encmb_effect_type = cst_exc_crs_gp;
1459: BEGIN
1512: v_dummy VARCHAR2(1);
1513: CURSOR c_pot_etde IS
1514: SELECT 'X'
1515: FROM IGS_PR_OU_TYPE pot,
1516: IGS_FI_ENC_DFLT_EFT etde
1517: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1518: pot.encumbrance_type = etde.encumbrance_type AND
1519: etde.s_encmb_effect_type IN (
1520: cst_rstr_ge_cp,
1747: course_cd = p_course_cd;
1748: CURSOR c_pot_etde IS
1749: SELECT etde.s_encmb_effect_type
1750: FROM IGS_PR_OU_TYPE pot,
1751: IGS_FI_ENC_DFLT_EFT etde
1752: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1753: pot. encumbrance_type = etde.encumbrance_type;
1754: CURSOR c_spc IS
1755: SELECT 'X'