APPS.IGS_PR_VAL_SPU dependencies on IGS_PR_STDNT_PR_OU

Line 37: -- record is related to a IGS_PR_STDNT_PR_OU with a

33:
34:
35: -- Purpose: When creating a Student Progression Unit record validate that the
36:
37: -- record is related to a IGS_PR_STDNT_PR_OU with a
38:
39: -- progression_outcome_type that relates to:
40:
41: -- a s_encmb_effect_type of EXC_CRS_U when s_unit_type = EXCLUDED or

Line 55: FROM IGS_PR_STDNT_PR_OU spo,

51: cp_see_type IGS_FI_ENC_DFLT_EFT.s_encmb_effect_type%TYPE) IS
52:
53: SELECT 'x'
54:
55: FROM IGS_PR_STDNT_PR_OU spo,
56:
57: IGS_PR_OU_TYPE pot,
58:
59: