APPS.IGS_IN_GEN_001 dependencies on IGS_FI_ENCMB_TYPE

Line 88: cst_academic CONSTANT IGS_FI_ENCMB_TYPE.s_encumbrance_cat%TYPE := 'ACADEMIC';

84: -- set exclusions don't directly affect the course, and as such only sometimes
85: -- result in a lamp. This indicator is only really applicable to 'COURSE'
86: -- level calls.
87: DECLARE
88: cst_academic CONSTANT IGS_FI_ENCMB_TYPE.s_encumbrance_cat%TYPE := 'ACADEMIC';
89: cst_sus_srvc CONSTANT
90: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_SRVC';
91: cst_rvk_srvc CONSTANT
92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';

Line 137: IGS_FI_ENCMB_TYPE et

133: pen.encumbrance_type,
134: pen.start_dt,
135: et.s_encumbrance_cat
136: FROM IGS_PE_PERS_ENCUMB pen,
137: IGS_FI_ENCMB_TYPE et
138: WHERE pen.person_id = p_person_id AND
139: pen.start_dt <= p_effective_dt AND
140: (pen.expiry_dt IS NULL OR
141: pen.expiry_dt > p_effective_dt) AND