APPS.IGS_PR_VAL_PRO dependencies on IGS_FI_ENC_DFLT_EFT

Line 80: IGS_FI_ENC_DFLT_EFT etde

76: v_dummy VARCHAR2(1);
77: CURSOR c_pot IS
78: SELECT 'X'
79: FROM IGS_PR_OU_TYPE pot,
80: IGS_FI_ENC_DFLT_EFT etde
81: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
82: pot.encumbrance_type = etde.encumbrance_type AND
83: etde.s_encmb_effect_type = cst_rstr_at_ty;
84: BEGIN

Line 148: IGS_FI_ENC_DFLT_EFT etde

144: v_dummy VARCHAR2(1);
145: CURSOR c_pot_etde IS
146: SELECT etde.s_encmb_effect_type
147: FROM IGS_PR_OU_TYPE pot,
148: IGS_FI_ENC_DFLT_EFT etde
149: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
150: pot.encumbrance_type = etde.encumbrance_type;
151: CURSOR c_pous IS
152: SELECT 'X'

Line 305: IGS_FI_ENC_DFLT_EFT etde

301: v_dummy VARCHAR2(1);
302: CURSOR c_pot IS
303: SELECT 'X'
304: FROM IGS_PR_OU_TYPE pot,
305: IGS_FI_ENC_DFLT_EFT etde
306: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
307: pot.encumbrance_type = etde.encumbrance_type AND
308: etde.s_encmb_effect_type = cst_exc_crs_gp;
309: BEGIN

Line 357: IGS_FI_ENC_DFLT_EFT etde

353: v_dummy VARCHAR2(1);
354: CURSOR c_pot IS
355: SELECT 'X'
356: FROM IGS_PR_OU_TYPE pot,
357: IGS_FI_ENC_DFLT_EFT etde
358: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
359: pot.encumbrance_type = etde.encumbrance_type AND
360: etde.s_encmb_effect_type IN ( cst_rstr_ge_cp,
361: cst_rstr_le_cp);

Line 439: IGS_FI_ENC_DFLT_EFT etde

435: poc.pro_sequence_number = p_sequence_number;
436: CURSOR c_pot_etde1 IS
437: SELECT 'X'
438: FROM IGS_PR_OU_TYPE pot,
439: IGS_FI_ENC_DFLT_EFT etde
440: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
441: pot.encumbrance_type = etde.encumbrance_type AND
442: etde.s_encmb_effect_type IN (
443: cst_exc_course,

Line 454: IGS_FI_ENC_DFLT_EFT etde

450: pous.pro_sequence_number = p_sequence_number;
451: CURSOR c_pot_etde2 IS
452: SELECT 'X'
453: FROM IGS_PR_OU_TYPE pot,
454: IGS_FI_ENC_DFLT_EFT etde
455: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
456: pot.encumbrance_type = etde.encumbrance_type AND
457: etde.s_encmb_effect_type = cst_exc_crs_us;
458: CURSOR c_popu IS

Line 467: IGS_FI_ENC_DFLT_EFT etde

463: popu.pro_sequence_number = p_sequence_number;
464: CURSOR c_pot_etde3 IS
465: SELECT 'X'
466: FROM IGS_PR_OU_TYPE pot,
467: IGS_FI_ENC_DFLT_EFT etde
468: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
469: pot.encumbrance_type = etde.encumbrance_type AND
470: etde.s_encmb_effect_type = cst_exc_crs_u;
471: CURSOR c_pot_etde4 IS

Line 474: IGS_FI_ENC_DFLT_EFT etde

470: etde.s_encmb_effect_type = cst_exc_crs_u;
471: CURSOR c_pot_etde4 IS
472: SELECT 'X'
473: FROM IGS_PR_OU_TYPE pot,
474: IGS_FI_ENC_DFLT_EFT etde
475: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
476: pot.encumbrance_type = etde.encumbrance_type AND
477: etde.s_encmb_effect_type = cst_rqrd_crs_u;
478: -- Added as per the FA110 PR ENH. Bug# 2658550

Line 489: IGS_FI_ENC_DFLT_EFT etde

485:
486: CURSOR c_pot_etde5 IS
487: SELECT 'X'
488: FROM IGS_PR_OU_TYPE pot,
489: IGS_FI_ENC_DFLT_EFT etde
490: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
491: pot.encumbrance_type = etde.encumbrance_type AND
492: etde.s_encmb_effect_type = cst_exe_fund;
493: BEGIN