APPS.IGS_EN_VAL_ENCMB dependencies on IGS_PE_UNT_SET_EXCL

Line 402: v_puse_start_dt IGS_PE_UNT_SET_EXCL.puse_start_dt%TYPE;

398: RETURN BOOLEAN AS
399:
400: BEGIN
401: DECLARE
402: v_puse_start_dt IGS_PE_UNT_SET_EXCL.puse_start_dt%TYPE;
403: v_expiry_dt IGS_PE_UNT_SET_EXCL.expiry_dt%TYPE;
404: CURSOR c_psd_ed IS
405: SELECT puse.puse_start_dt,
406: puse.expiry_dt

Line 403: v_expiry_dt IGS_PE_UNT_SET_EXCL.expiry_dt%TYPE;

399:
400: BEGIN
401: DECLARE
402: v_puse_start_dt IGS_PE_UNT_SET_EXCL.puse_start_dt%TYPE;
403: v_expiry_dt IGS_PE_UNT_SET_EXCL.expiry_dt%TYPE;
404: CURSOR c_psd_ed IS
405: SELECT puse.puse_start_dt,
406: puse.expiry_dt
407: FROM IGS_PE_PERSENC_EFFCT pee,

Line 408: IGS_PE_UNT_SET_EXCL puse

404: CURSOR c_psd_ed IS
405: SELECT puse.puse_start_dt,
406: puse.expiry_dt
407: FROM IGS_PE_PERSENC_EFFCT pee,
408: IGS_PE_UNT_SET_EXCL puse
409: WHERE pee.person_id = p_person_id AND
410: pee.s_encmb_effect_type = 'EXC_CRS_US' AND
411: pee.course_cd = p_course_cd AND
412: puse.person_id = pee.person_id AND