APPS.IGS_AD_GEN_012 dependencies on IGS_CA_INST

Line 517: IGS_CA_INST ci,

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
521: daiv.alias_val = TRUNC(SYSDATE) AND

Line 563: cp_start_dt IGS_CA_INST.start_dt%TYPE,

559:
560: Rec_IGS_AD_PS_APPL c_aca%ROWTYPE;
561:
562: CURSOR c_acaiv (
563: cp_start_dt IGS_CA_INST.start_dt%TYPE,
564: cp_person_id IGS_AD_APPL.person_id%TYPE,
565: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
566: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
567: SELECT acaiv.person_id,

Line 588: AND EXISTS (SELECT 'x' FROM igs_ca_inst ci

584: AND acaiv.nominated_course_cd = cp_nominated_course_cd
585: AND EXISTS (SELECT 'x' FROM igs_ad_ou_stat aos
586: WHERE aos.adm_outcome_status = acaiv.adm_outcome_status
587: AND aos.s_adm_outcome_status IN (cst_rejected, cst_no_quota))
588: AND EXISTS (SELECT 'x' FROM igs_ca_inst ci
589: WHERE ci.cal_type = NVL (acaiv.adm_cal_type,aa.adm_cal_type)
590: AND ci.sequence_number = NVL (acaiv.adm_ci_sequence_number,aa.adm_ci_sequence_number)
591: AND ci.start_dt < cp_start_dt);
592: