DBA Data[Home] [Help]

APPS.IGS_CA_VAL_QLITY dependencies on IGS_GE_S_GEN_CAL_CON

Line 268: FROM IGS_GE_S_GEN_CAL_CON sgcc,

264: CURSOR c_dai_sgcc (
265: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
266: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
267: SELECT count(*)
268: FROM IGS_GE_S_GEN_CAL_CON sgcc,
269: IGS_CA_DA_INST dai
270: WHERE dai.CAL_TYPE = cp_cal_type AND
271: dai.ci_sequence_number = cp_sequence_number AND
272: dai.DT_ALIAS = sgcc.census_dt_alias AND

Line 2463: FROM IGS_GE_S_GEN_CAL_CON sgcc,

2459: SELECT 'x'
2460: FROM dual
2461: WHERE EXISTS (
2462: SELECT *
2463: FROM IGS_GE_S_GEN_CAL_CON sgcc,
2464: IGS_CA_DA_INST_V daiv
2465: WHERE sgcc.s_control_num = 1 AND
2466: daiv.CAL_TYPE = cp_cal_type AND
2467: daiv.ci_sequence_number = cp_sequence_number AND