DBA Data[Home] [Help]

APPS.IGS_AD_GEN_001 dependencies on IGS_CA_TYPE

Line 402: IGS_CA_TYPE ct,

398: daiv.cal_type,
399: daiv.ci_sequence_number
400: FROM IGS_CA_INST_REL cir,
401: IGS_CA_DA_INST_V daiv,
402: IGS_CA_TYPE ct,
403: IGS_CA_TYPE ct2,
404: IGS_EN_CAL_CONF secc
405: WHERE secc.s_control_num = 1 AND
406: TRUNC(daiv.alias_val) = TRUNC(SYSDATE) AND

Line 403: IGS_CA_TYPE ct2,

399: daiv.ci_sequence_number
400: FROM IGS_CA_INST_REL cir,
401: IGS_CA_DA_INST_V daiv,
402: IGS_CA_TYPE ct,
403: IGS_CA_TYPE ct2,
404: IGS_EN_CAL_CONF secc
405: WHERE secc.s_control_num = 1 AND
406: TRUNC(daiv.alias_val) = TRUNC(SYSDATE) AND
407: daiv.dt_alias = secc.enr_cleanup_dt_alias AND