APPS.IGS_CA_COMPUTE_DA_VAL_PKG dependencies on IGS_CA_DA_INST_OFST

Line 359: FROM IGS_CA_DA_INST_OFST

355: IS
356:
357: CURSOR cp_get_ofst_dt(cp_dt_alias VARCHAR2,cp_da_seq_num NUMBER,cp_cal_type VARCHAR2,cp_seq_num NUMBER) IS
358: SELECT offset_dt_alias,offset_dai_sequence_number,offset_cal_type,offset_ci_sequence_number,ofst_override
359: FROM IGS_CA_DA_INST_OFST
360: WHERE dt_alias = cp_dt_alias AND
361: dai_sequence_number = cp_da_seq_num AND
362: cal_type = cp_cal_type AND
363: ci_sequence_number = cp_seq_num;

Line 407: FROM IGS_CA_DA_INST_OFST

403: -- Cursor to check if the DAI has an offset.
404: CURSOR chk_dai_ofst(cp_dt_alias VARCHAR2,cp_da_seq_num NUMBER,cp_cal_type VARCHAR2,cp_seq_num NUMBER)
405: IS
406: SELECT offset_dt_alias,offset_dai_sequence_number,offset_cal_type,offset_ci_sequence_number,day_offset,week_offset,month_offset,year_offset,ofst_override
407: FROM IGS_CA_DA_INST_OFST
408: WHERE dt_alias = cp_dt_alias AND
409: dai_sequence_number = cp_da_seq_num AND
410: cal_type = cp_cal_type AND
411: ci_sequence_number = cp_seq_num;