APPS.IGS_EN_GEN_002 dependencies on IGS_CA_DA_INST

Line 308: cp_acad_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

304: v_sca_rec c_sca%ROWTYPE;
305:
306:
307: CURSOR c_daiv (
308: cp_acad_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
309: cp_acad_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
310: SELECT MIN(IGS_CA_GEN_001.calp_set_alias_value
311: (
312: daiv.absolute_val,

Line 309: cp_acad_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

305:
306:
307: CURSOR c_daiv (
308: cp_acad_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
309: cp_acad_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
310: SELECT MIN(IGS_CA_GEN_001.calp_set_alias_value
311: (
312: daiv.absolute_val,
313: IGS_CA_GEN_002.cals_clc_dt_from_dai

Line 322: FROM IGS_CA_DA_INST daiv,

318: daiv.sequence_number
319: )
320: )
321: ) alias_val
322: FROM IGS_CA_DA_INST daiv,
323: IGS_EN_CAL_CONF secc
324: WHERE daiv.cal_type = cp_acad_cal_type AND
325: daiv.ci_sequence_number = cp_acad_ci_sequence_number AND
326: secc.commencement_dt_alias = daiv.dt_alias AND