APPS.IGS_GR_VAL_GR dependencies on IGS_PE_PERS_ENCUMB

Line 28: FROM IGS_PE_PERS_ENCUMB pen

24: v_effect_exists BOOLEAN;
25: CURSOR c_pen IS
26: SELECT pen.encumbrance_type,
27: pen.start_dt
28: FROM IGS_PE_PERS_ENCUMB pen
29: WHERE pen.person_id = p_person_id AND
30: TRUNC(p_effective_dt) BETWEEN TRUNC(pen.start_dt) AND
31: TRUNC(NVL(pen.expiry_dt, p_effective_dt));
32: CURSOR c_pee_seet(

Line 33: cp_pen_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

29: WHERE pen.person_id = p_person_id AND
30: TRUNC(p_effective_dt) BETWEEN TRUNC(pen.start_dt) AND
31: TRUNC(NVL(pen.expiry_dt, p_effective_dt));
32: CURSOR c_pee_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

Line 34: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS

30: TRUNC(p_effective_dt) BETWEEN TRUNC(pen.start_dt) AND
31: TRUNC(NVL(pen.expiry_dt, p_effective_dt));
32: CURSOR c_pee_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