APPS.IGS_CA_GEN_002 dependencies on IGS_CA_DA_INST_OFST

Line 1107: -- IGS_CA_DA_INST_OFST.

1103: RETURN DATE AS
1104: gv_other_detail VARCHAR2(255);
1105: BEGIN -- calp_clc_dt_from_dai
1106: -- Calculate a IGS_CA_DA_INST.alias_value from a
1107: -- IGS_CA_DA_INST_OFST.
1108: DECLARE
1109: CURSOR c_daio IS
1110: SELECT daio.DT_ALIAS,
1111: daio.dai_sequence_number,

Line 1122: FROM IGS_CA_DA_INST_OFST daio

1118: daio.day_offset,
1119: daio.week_offset,
1120: daio.month_offset,
1121: daio.year_offset
1122: FROM IGS_CA_DA_INST_OFST daio
1123: WHERE daio.DT_ALIAS = p_dt_alias AND
1124: daio.dai_sequence_number = p_dai_sequence_number AND
1125: daio.CAL_TYPE = p_cal_type AND
1126: daio.ci_sequence_number = p_ci_sequence_number;

Line 1156: -- Find IGS_CA_DA_INST_OFST

1152: dt_alias_inst_offset_c_row IGS_CA_DA_INST_OFCNT%ROWTYPE;
1153: v_other_detail VARCHAR(255);
1154: BEGIN
1155: p_message_name :=NULL;
1156: -- Find IGS_CA_DA_INST_OFST
1157: OPEN c_daio;
1158: FETCH c_daio INTO v_c_daio_rec;
1159: IF (c_daio%NOTFOUND) THEN
1160: CLOSE c_daio;