APPS.IGS_GR_VAL_GR dependencies on IGS_EN_ENCMB_EFCTTYP

Line 17: p_encmb_effect_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ,

13: FUNCTION enrp_val_encmb_efct(
14: p_person_id HZ_PARTIES.party_id%TYPE ,
15: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
16: p_effective_dt DATE ,
17: p_encmb_effect_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ,
18: p_message_name OUT NOCOPY VARCHAR2 )
19: RETURN BOOLEAN AS
20: BEGIN -- enrp_val_encmb_efct
21: -- This routines checks if an encumbrance effect applies to a person.

Line 37: IGS_EN_ENCMB_EFCTTYP_V seet

33: cp_pen_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
34: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
35: SELECT 'x'
36: FROM IGS_PE_PERSENC_EFFCT pee,
37: IGS_EN_ENCMB_EFCTTYP_V seet
38: WHERE pee.person_id = p_person_id AND
39: pee.encumbrance_type = cp_pen_encumbrance_type AND
40: TRUNC(pee.pen_start_dt) = TRUNC(cp_pen_start_dt) AND
41: pee.s_encmb_effect_type = p_encmb_effect_type AND