APPS.IGS_PR_VAL_SPUS dependencies on IGS_PR_OU_TYPE

Line 32: -- IGS_PR_OU_TYPE that relates to a s_encmb_effect_type of EXC_CRS_US

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
35:
36: v_exists VARCHAR2(1);

Line 46: IGS_PR_OU_TYPE pot,

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
49:
50: WHERE spo.person_id = p_person_id AND