APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_STDNT_PR_PS

Line 1756: FROM IGS_PR_STDNT_PR_PS

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'
1756: FROM IGS_PR_STDNT_PR_PS
1757: WHERE person_id = p_person_id AND
1758: spo_course_cd = p_course_cd AND
1759: spo_sequence_number = p_sequence_number;
1760: CURSOR c_spus IS

Line 1821: -- then at least one record must exist in the IGS_PR_STDNT_PR_PS table

1817: CLOSE c_sca;
1818: END IF;
1819: FOR v_pot_etde_rec IN c_pot_etde LOOP
1820: -- If related encumbrance effects contain SUS_COURSE or EXC_COURSE,
1821: -- then at least one record must exist in the IGS_PR_STDNT_PR_PS table
1822: IF v_pot_etde_rec.s_encmb_effect_type IN (
1823: cst_sus_course,
1824: cst_exc_course) THEN
1825: OPEN c_spc;