DBA Data[Home] [Help]

APPS.IGS_EN_GEN_006 dependencies on IGS_LOOKUPS_VIEW

Line 625: v_s_adm_cndtnl_offer_status IGS_LOOKUPS_view.lookup_code%TYPE DEFAULT NULL;

621: v_cndtnl_off_must_be_stsfd_ind IGS_AD_PS_APPL_INST_APLINST_V.cndtnl_offer_must_be_stsfd_ind%TYPE;
622: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
623: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
624: v_cop_offered_ind IGS_PS_OFR_PAT.offered_ind%TYPE;
625: v_s_adm_cndtnl_offer_status IGS_LOOKUPS_view.lookup_code%TYPE DEFAULT NULL;
626:
627: --modified cursor for performance bug 4968380
628: CURSOR c_person IS
629: SELECT DECODE(Pbv.DATE_OF_DEATH,NULL,NVL(PE.DECEASED_IND,'N'),'Y') DECEASED_IND