APPS.IGS_AD_AC_COMP dependencies on IGS_CA_INST_ALL

Line 459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

455: AND ads.closed_ind = 'N'
456: AND apai.adm_doc_status = ads.adm_doc_status;
457:
458:
459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;

Line 460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

456: AND apai.adm_doc_status = ads.adm_doc_status;
457:
458:
459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

Line 461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;

457:
458:
459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
465: l_records_not_found BOOLEAN := TRUE;

Line 462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

458:
459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
465: l_records_not_found BOOLEAN := TRUE;
466: