APPS.IGS_CA_COMPUTE_DA_VAL_PKG dependencies on IGS_CA_DA_INST

Line 114: FROM IGS_CA_DA_INST

110:
111: CURSOR count_dai_in_ci(cp_dt_alias VARCHAR2, cp_cal_type VARCHAR2, cp_seq_num NUMBER)
112: IS
113: SELECT count(*)
114: FROM IGS_CA_DA_INST
115: WHERE dt_alias = cp_dt_alias AND
116: cal_type = cp_cal_type AND
117: ci_sequence_number = cp_seq_num;
118:

Line 123: FROM IGS_CA_DA_INST_V

119:
120: CURSOR get_da_inst_val(cp_dt_alias VARCHAR2, cp_cal_type VARCHAR2, cp_seq_num NUMBER)
121: IS
122: SELECT alias_val
123: FROM IGS_CA_DA_INST_V
124: WHERE dt_alias = cp_dt_alias AND
125: cal_type = cp_cal_type AND
126: ci_sequence_number = cp_seq_num;
127:

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;