[Home] [Help]
230: FROM IGS_AD_CAL_CONF sacc
231: WHERE s_control_num = 1;
232: CURSOR c_daiv IS
233: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
234: FROM IGS_CA_DA_INST daiv,
235: IGS_AD_PERD_AD_CAT apac
236: WHERE daiv.dt_alias = p_dt_alias AND
237: apac.adm_cal_type = p_adm_cal_type AND
238: apac.adm_ci_sequence_number = p_adm_ci_sequence_number AND
248: apcood.dai_sequence_number = daiv.sequence_number)
249: ORDER BY 1 desc;
250: CURSOR c_daiv2 IS
251: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
252: FROM IGS_CA_DA_INST daiv
253: WHERE daiv.cal_type = p_adm_cal_type AND
254: daiv.ci_sequence_number = p_adm_ci_sequence_number AND
255: daiv.dt_alias = p_dt_alias AND
256: daiv.sequence_number = v_dai_sequence_number;
331: (v_apcood_rec.attendance_mode IS NULL OR
332: v_apcood_rec.attendance_mode = p_attendance_mode) AND
333: (v_apcood_rec.attendance_type IS NULL OR
334: v_apcood_rec.attendance_type = p_attendance_type)) THEN
335: --Match on the components and save the IGS_CA_DA_INST_V key for the
336: --Record that matches with the highest number of components
337: IF (v_apcood_rec.s_admission_process_type IS NOT NULL) THEN
338: IF (v_apcood_rec.s_admission_process_type = p_s_admission_process_type) THEN
339: v_curr_component_ctr := v_curr_component_ctr + 1;