APPS.IGS_PS_GEN_004 dependencies on IGS_CA_DA_INST_PAIR

Line 1235: IGS_CA_DA_INST_PAIR daip,

1231: CURSOR c_m_alias_val2 IS
1232: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
1233: FROM IGS_CA_DA_INST dai1,
1234: IGS_CA_DA_INST dai2,
1235: IGS_CA_DA_INST_PAIR daip,
1236: IGS_CA_INST ci,
1237: IGS_CA_TYPE ct,
1238: IGS_CA_STAT cs
1239: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND

Line 1267: IGS_CA_DA_INST_PAIR daip

1263: cs.s_cal_status = cst_active AND
1264: EXISTS (SELECT 'x'
1265: FROM IGS_CA_DA_INST dai1,
1266: IGS_CA_DA_INST dai2,
1267: IGS_CA_DA_INST_PAIR daip
1268: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
1269: dai1.DT_ALIAS = daip.DT_ALIAS AND
1270: dai1.sequence_number = daip.dai_sequence_number AND
1271: dai1.CAL_TYPE = daip.CAL_TYPE AND