APPS.IGS_CA_GEN_002 dependencies on IGS_CA_DA_INST_OFCNT

Line 420: FROM IGS_CA_DA_INST_OFCNT daoc

416: CURSOR c_daoc IS
417: SELECT daoc.S_DT_OFFSET_CONSTRAINT_TYPE,
418: daoc.constraint_condition,
419: daoc.constraint_resolution
420: FROM IGS_CA_DA_INST_OFCNT daoc
421: WHERE daoc.DT_ALIAS = p_dt_alias AND
422: daoc.dai_sequence_number = p_sequence_number AND
423: daoc.CAL_TYPE = p_cal_type AND
424: daoc.ci_sequence_number = p_ci_sequence_number;

Line 1144: FROM IGS_CA_DA_INST_OFCNT daioc

1140: SELECT daioc.DT_ALIAS,
1141: daioc.dai_sequence_number,
1142: daioc.CAL_TYPE,
1143: daioc.ci_sequence_number
1144: FROM IGS_CA_DA_INST_OFCNT daioc
1145: WHERE daioc.DT_ALIAS = p_dt_alias AND
1146: daioc.dai_sequence_number = p_dai_sequence_number AND
1147: daioc.CAL_TYPE = p_cal_type AND
1148: daioc.ci_sequence_number = p_ci_sequence_number;

Line 1152: dt_alias_inst_offset_c_row IGS_CA_DA_INST_OFCNT%ROWTYPE;

1148: daioc.ci_sequence_number = p_ci_sequence_number;
1149: v_c_dai_rec c_dai%ROWTYPE;
1150: v_c_daioc_rec c_daioc%ROWTYPE;
1151: v_alias_value DATE DEFAULT NULL;
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