APPS.IGS_EN_VAL_PEN dependencies on IGS_FI_ENC_DFLT_EFT

Line 37: FROM IGS_FI_ENC_DFLT_EFT etde

33: v_return_type VARCHAR2(1);
34: v_start_dt DATE;
35: CURSOR c_etde IS
36: SELECT etde.s_encmb_effect_type
37: FROM IGS_FI_ENC_DFLT_EFT etde
38: WHERE encumbrance_type = p_encumbrance_type;
39: BEGIN
40: --- Set the default message number
41: p_message_name := null;

Line 186: cp_enc_type IGS_FI_ENC_DFLT_EFT.encumbrance_type%TYPE)IS

182: gv_rstr_at_ty BOOLEAN;
183: gv_rstr_ge_cp BOOLEAN;
184: gv_rstr_le_cp BOOLEAN;
185: CURSOR gc_encmb_eff (
186: cp_enc_type IGS_FI_ENC_DFLT_EFT.encumbrance_type%TYPE)IS
187: SELECT etde.s_encmb_effect_type,
188: seet.encumbrance_level
189: FROM IGS_FI_ENC_DFLT_EFT etde,
190: -- s_encmb_effect_type seet

Line 189: FROM IGS_FI_ENC_DFLT_EFT etde,

185: CURSOR gc_encmb_eff (
186: cp_enc_type IGS_FI_ENC_DFLT_EFT.encumbrance_type%TYPE)IS
187: SELECT etde.s_encmb_effect_type,
188: seet.encumbrance_level
189: FROM IGS_FI_ENC_DFLT_EFT etde,
190: -- s_encmb_effect_type seet
191: IGS_EN_ENCMB_EFCTTYP_V SEET
192: WHERE etde.encumbrance_type = cp_enc_type AND
193: seet.s_encmb_effect_type = etde.s_encmb_effect_type

Line 199: p_encmb_effect_type IGS_FI_ENC_DFLT_EFT.s_encmb_effect_type%TYPE,

195: BEGIN
196: DECLARE
197: FUNCTION enrpl_val_rest_effects(
198: p_validation_level VARCHAR2,
199: p_encmb_effect_type IGS_FI_ENC_DFLT_EFT.s_encmb_effect_type%TYPE,
200: p_message_name OUT NOCOPY varchar2)
201: RETURN BOOLEAN IS
202: BEGIN
203: DECLARE