APPS.IGS_PR_VAL_SPUS dependencies on IGS_PR_STDNT_PR_OU

Line 30: -- the record is related to a IGS_PR_STDNT_PR_OU with a

26:
27: -- Purpose: When creating a Student Progression Unit Set record validate that
28:
29:
30: -- the record is related to a IGS_PR_STDNT_PR_OU with a
31:
32: -- IGS_PR_OU_TYPE that relates to a s_encmb_effect_type of EXC_CRS_US
33:
34: DECLARE

Line 44: FROM IGS_PR_STDNT_PR_OU spo,

40: cp_see_type IGS_FI_ENC_DFLT_EFT.s_encmb_effect_type%TYPE) IS
41:
42: SELECT 'x'
43:
44: FROM IGS_PR_STDNT_PR_OU spo,
45:
46: IGS_PR_OU_TYPE pot,
47:
48: IGS_FI_ENC_DFLT_EFT etde