APPS.IGS_EN_VAL_ENCMB dependencies on IGS_PE_PERS_UNT_EXCL

Line 30: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;

26: RETURN BOOLEAN AS
27:
28: BEGIN
29: DECLARE
30: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;
31: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;
32: CURSOR c_psd_ed IS
33: SELECT pue.pue_start_dt,
34: pue.expiry_dt

Line 31: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;

27:
28: BEGIN
29: DECLARE
30: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;
31: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;
32: CURSOR c_psd_ed IS
33: SELECT pue.pue_start_dt,
34: pue.expiry_dt
35: FROM IGS_PE_PERSENC_EFFCT pee,

Line 36: IGS_PE_PERS_UNT_EXCL pue

32: CURSOR c_psd_ed IS
33: SELECT pue.pue_start_dt,
34: pue.expiry_dt
35: FROM IGS_PE_PERSENC_EFFCT pee,
36: IGS_PE_PERS_UNT_EXCL pue
37: WHERE pee.person_id = p_person_id AND
38: pee.s_encmb_effect_type = 'EXC_CRS_U' AND
39: pee.course_cd = p_course_cd AND
40: pue.person_id = pee.person_id AND