APPS.IGS_CA_GEN_002 dependencies on IGS_CA_DA_INST_PAIR

Line 255: IGS_CA_DA_INST_PAIR daip,

251: CURSOR c_m_alias_val2a IS
252: SELECT TRUNC(dai2.absolute_val)
253: FROM IGS_CA_DA_INST dai1,
254: IGS_CA_DA_INST dai2,
255: IGS_CA_DA_INST_PAIR daip,
256: IGS_CA_INST ci,
257: IGS_CA_TYPE ct,
258: IGS_CA_STAT cs
259: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND

Line 278: IGS_CA_DA_INST_PAIR daip,

274: CURSOR c_m_alias_val2b IS
275: SELECT TRUNC(dai1.absolute_val)
276: FROM IGS_CA_DA_INST dai1,
277: IGS_CA_DA_INST dai2,
278: IGS_CA_DA_INST_PAIR daip,
279: IGS_CA_INST ci,
280: IGS_CA_TYPE ct,
281: IGS_CA_STAT cs
282: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND

Line 311: IGS_CA_DA_INST_PAIR daip

307: cs.s_cal_status = cst_active AND
308: EXISTS (SELECT 'x'
309: FROM IGS_CA_DA_INST dai1,
310: IGS_CA_DA_INST dai2,
311: IGS_CA_DA_INST_PAIR daip
312: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
313: dai1.DT_ALIAS = daip.DT_ALIAS AND
314: dai1.sequence_number = daip.dai_sequence_number AND
315: dai1.CAL_TYPE = daip.CAL_TYPE AND

Line 743: IGS_CA_DA_INST_PAIR daip,

739: CURSOR c_m_alias_val2 IS
740: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
741: FROM IGS_CA_DA_INST dai1,
742: IGS_CA_DA_INST dai2,
743: IGS_CA_DA_INST_PAIR daip,
744: IGS_CA_INST ci,
745: IGS_CA_TYPE ct,
746: IGS_CA_STAT cs
747: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND

Line 774: IGS_CA_DA_INST_PAIR daip

770: cs.s_cal_status = cst_active AND
771: EXISTS (SELECT 'x'
772: FROM IGS_CA_DA_INST dai1,
773: IGS_CA_DA_INST dai2,
774: IGS_CA_DA_INST_PAIR daip
775: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
776: dai1.DT_ALIAS = daip.DT_ALIAS AND
777: dai1.sequence_number = daip.dai_sequence_number AND
778: dai1.CAL_TYPE = daip.CAL_TYPE AND