DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SPO dependencies on IGS_FI_ENC_DFLT_EFT

Line 1395: IGS_FI_ENC_DFLT_EFT etde

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

Line 1455: IGS_FI_ENC_DFLT_EFT etde

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

Line 1516: IGS_FI_ENC_DFLT_EFT etde

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,

Line 1751: IGS_FI_ENC_DFLT_EFT etde

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'