DBA Data[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_CA_TYPE

Line 1713: IGS_CA_TYPE ct,

1709: SELECT ci2.CAL_TYPE,
1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,
1712: IGS_CA_INST ci2,
1713: IGS_CA_TYPE ct,
1714: IGS_CA_TYPE ct2
1715: WHERE ci.CAL_TYPE = cp_ass_cal_type AND
1716: ci.sequence_number = cp_ass_sequence_number AND
1717: ci.CAL_TYPE = ct.CAL_TYPE AND

Line 1714: IGS_CA_TYPE ct2

1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,
1712: IGS_CA_INST ci2,
1713: IGS_CA_TYPE ct,
1714: IGS_CA_TYPE ct2
1715: WHERE ci.CAL_TYPE = cp_ass_cal_type AND
1716: ci.sequence_number = cp_ass_sequence_number AND
1717: ci.CAL_TYPE = ct.CAL_TYPE AND
1718: ct.S_CAL_CAT = cst_assessment AND