APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_STDNT_PR_UNIT

Line 1774: FROM IGS_PR_STDNT_PR_UNIT

1770: course_cd = p_course_cd AND
1771: spo_sequence_number = p_sequence_number;
1772: CURSOR c_spu_1 IS
1773: SELECT 'X'
1774: FROM IGS_PR_STDNT_PR_UNIT
1775: WHERE person_id = p_person_id AND
1776: course_cd = p_course_cd AND
1777: spo_sequence_number = p_sequence_number AND
1778: s_unit_type = cst_excluded;

Line 1781: FROM IGS_PR_STDNT_PR_UNIT

1777: spo_sequence_number = p_sequence_number AND
1778: s_unit_type = cst_excluded;
1779: CURSOR c_spu_2 IS
1780: SELECT 'X'
1781: FROM IGS_PR_STDNT_PR_UNIT
1782: WHERE person_id = p_person_id AND
1783: course_cd = p_course_cd AND
1784: spo_sequence_number = p_sequence_number AND
1785: s_unit_type = cst_required;

Line 1849: -- exist in the IGS_PR_STDNT_PR_UNIT table with s_unit_type of 'EXCLUDE

1845: END IF;
1846: CLOSE c_spus;
1847: END IF;
1848: -- If related encumbrance effects contain EXC_CRS_U, then a record must
1849: -- exist in the IGS_PR_STDNT_PR_UNIT table with s_unit_type of 'EXCLUDE
1850: IF v_pot_etde_rec.s_encmb_effect_type = cst_exc_crs_u THEN
1851: OPEN c_spu_1;
1852: FETCH c_spu_1 INTO v_dummy;
1853: IF c_spu_1%NOTFOUND THEN

Line 1862: -- exist in the IGS_PR_STDNT_PR_UNIT table with s_unit_type of 'REQUIRED'

1858: END IF;
1859: CLOSE c_spu_1;
1860: END IF;
1861: -- If related encumbrance effects contain RQRD_CRS_U, then a record must
1862: -- exist in the IGS_PR_STDNT_PR_UNIT table with s_unit_type of 'REQUIRED'
1863: IF v_pot_etde_rec.s_encmb_effect_type = cst_rqrd_crs_u THEN
1864: OPEN c_spu_2;
1865: FETCH c_spu_2 INTO v_dummy;
1866: IF c_spu_2%NOTFOUND THEN