APPS.IGS_AD_GEN_012 dependencies on IGS_CA_DA_INST_V

Line 516: FROM IGS_CA_DA_INST_V daiv,

512: CURSOR c_daiv IS
513: SELECT daiv.cal_type,
514: daiv.ci_sequence_number,
515: ci.start_dt
516: FROM IGS_CA_DA_INST_V daiv,
517: IGS_CA_INST ci,
518: IGS_AD_CAL_CONF sacco
519: WHERE sacco.s_control_num = 1 AND
520: daiv.dt_alias = sacco.initialise_adm_perd_dt_alias AND

Line 637: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

633: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
634: v_adm_cndtnl_offer_status IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
635: v_late_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE;
636: v_crv_version_number NUMBER;
637: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
638: v_expected_completion_yr IGS_AD_PS_APPL_INST.expected_completion_yr%TYPE;
639: v_expected_completion_perd
640: IGS_AD_PS_APPL_INST.expected_completion_perd%TYPE;
641: v_completion_dt DATE;