DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_PE_PERS_UNT_EXCL

Line 835: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;

831: RETURN BOOLEAN AS
832:
833: BEGIN
834: DECLARE
835: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;
836: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;
837: CURSOR c_psd_ed IS
838: SELECT pue.pue_start_dt,
839: pue.expiry_dt

Line 836: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;

832:
833: BEGIN
834: DECLARE
835: v_pue_start_dt IGS_PE_PERS_UNT_EXCL.pue_start_dt%TYPE;
836: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;
837: CURSOR c_psd_ed IS
838: SELECT pue.pue_start_dt,
839: pue.expiry_dt
840: FROM IGS_PE_PERSENC_EFFCT pee,

Line 841: IGS_PE_PERS_UNT_EXCL pue

837: CURSOR c_psd_ed IS
838: SELECT pue.pue_start_dt,
839: pue.expiry_dt
840: FROM IGS_PE_PERSENC_EFFCT pee,
841: IGS_PE_PERS_UNT_EXCL pue
842: WHERE pee.person_id = p_person_id AND
843: pee.s_encmb_effect_type = 'EXC_CRS_U' AND
844: pee.course_cd = p_course_cd AND
845: pue.person_id = pee.person_id AND