DBA Data[Home] [Help]

APPS.IGS_GR_VAL_GR dependencies on IGS_EN_ENCMB_EFCTTYP_V

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