DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_STDNT_PR_FND

Line 1768: FROM IGS_PR_STDNT_PR_FND

1764: course_cd = p_course_cd AND
1765: spo_sequence_number = p_sequence_number;
1766: CURSOR c_spuf IS
1767: SELECT 'X'
1768: FROM IGS_PR_STDNT_PR_FND
1769: WHERE person_id = p_person_id AND
1770: course_cd = p_course_cd AND
1771: spo_sequence_number = p_sequence_number;
1772: CURSOR c_spu_1 IS

Line 1905: -- a record must exist in the IGS_PR_STDNT_PR_FND table

1901: --
1902: -- Start of new code as per the FA110 TD. Bug# 2658550.
1903: --
1904: -- If related encumbrance effects contain 'EX_SP_AWD' or 'EX_SP_DISB', then
1905: -- a record must exist in the IGS_PR_STDNT_PR_FND table
1906: --
1907: IF v_pot_etde_rec.s_encmb_effect_type IN (cst_ex_sp_awd,cst_ex_sp_disb) THEN
1908: OPEN c_spuf;
1909: FETCH c_spuf INTO v_dummy;