[Home] [Help]
196: v_last_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
197: v_last_alias_type IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
198: v_last_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
199: v_last_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
200: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
201: v_out_of_order BOOLEAN;
202: v_strt_counter NUMBER;
203: v_end_counter NUMBER;
204: v_total_perc NUMBER;
275: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
276: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
277: SELECT uop.unit_cd
278: FROM IGS_PS_UNIT_OFR_PAT uop,
279: IGS_PS_UNIT_VER uv
280: WHERE uop.CAL_TYPE = cp_cal_type AND
281: uop.ci_sequence_number = cp_sequence_number AND
282: uv.unit_cd = uop.unit_cd AND
283: uv.version_number = uop.version_number AND