eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_006 dependencies on IGS_AD_PS_APPL

Line 619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;

615: v_excluded BOOLEAN;
616:
617: v_message_name VARCHAR2(30);
618:
619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;
620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
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;

Line 620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;

616:
617: v_message_name VARCHAR2(30);
618:
619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;
620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
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;

Line 621: v_cndtnl_off_must_be_stsfd_ind IGS_AD_PS_APPL_INST_APLINST_V.cndtnl_offer_must_be_stsfd_ind%TYPE;

617: v_message_name VARCHAR2(30);
618:
619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;
620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
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;

Line 735: IGS_AD_PS_APPL_INST acai,

731: acai.adm_cndtnl_offer_status ADM_CNDTNL_OFFER_STATUS,
732: acai.cndtnl_offer_must_be_stsfd_ind CNDTNL_OFFER_MUST_BE_STSFD_IND,
733: acai.adm_offer_resp_status ADM_OFFER_RESP_STATUS
734: FROM
735: IGS_AD_PS_APPL_INST acai,
736: IGS_AD_APPL aa,
737: IGS_CA_INST ci,
738: IGS_AD_PS_APPL aca,
739: IGS_PS_VER crv

Line 738: IGS_AD_PS_APPL aca,

734: FROM
735: IGS_AD_PS_APPL_INST acai,
736: IGS_AD_APPL aa,
737: IGS_CA_INST ci,
738: IGS_AD_PS_APPL aca,
739: IGS_PS_VER crv
740: WHERE
741: aa.person_id = acai.person_id AND
742: aa.admission_appl_number = acai.admission_appl_number AND