APPS.IGS_CA_GEN_002 dependencies on IGS_CA_STAT

Line 102: IGS_CA_STAT cs

98: SELECT TRUNC(dai.absolute_val)
99: FROM IGS_CA_DA_INST dai,
100: IGS_CA_INST ci,
101: IGS_CA_TYPE ct,
102: IGS_CA_STAT cs
103: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
104: dai.ci_sequence_number = ci.sequence_number AND
105: ci.CAL_TYPE = ct.CAL_TYPE AND
106: ct.S_CAL_CAT = cst_holiday AND

Line 116: IGS_CA_STAT cs

112: SELECT TRUNC(dai.absolute_val)
113: FROM IGS_CA_DA_INST dai,
114: IGS_CA_INST ci,
115: IGS_CA_TYPE ct,
116: IGS_CA_STAT cs
117: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
118: dai.ci_sequence_number = ci.sequence_number AND
119: ci.CAL_TYPE = ct.CAL_TYPE AND
120: ct.S_CAL_CAT = cst_holiday AND

Line 132: IGS_CA_STAT cs

128: FROM IGS_CA_TYPE ct
129: WHERE ct.S_CAL_CAT = cst_holiday AND
130: EXISTS (SELECT 'x'
131: FROM IGS_CA_INST ci,
132: IGS_CA_STAT cs
133: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
134: ci.CAL_STATUS = cs.CAL_STATUS AND
135: cs.s_cal_status = cst_active AND
136: EXISTS (SELECT 'x'

Line 258: IGS_CA_STAT cs

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
260: ct.S_CAL_CAT = cst_holiday AND
261: cs.CAL_STATUS = ci.CAL_STATUS AND
262: cs.s_cal_status = cst_active AND

Line 281: IGS_CA_STAT cs

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
283: ct.S_CAL_CAT = cst_holiday AND
284: cs.CAL_STATUS = ci.CAL_STATUS AND
285: cs.s_cal_status = cst_active AND

Line 304: IGS_CA_STAT cs

300: FROM IGS_CA_TYPE ct
301: WHERE ct.S_CAL_CAT = cst_holiday AND
302: EXISTS (SELECT 'x'
303: FROM IGS_CA_INST ci,
304: IGS_CA_STAT cs
305: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
306: ci.CAL_STATUS = cs.CAL_STATUS AND
307: cs.s_cal_status = cst_active AND
308: EXISTS (SELECT 'x'

Line 623: IGS_CA_STAT cs

619: SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
620: FROM IGS_CA_DA_INST dai,
621: IGS_CA_INST ci,
622: IGS_CA_TYPE ct,
623: IGS_CA_STAT cs
624: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
625: ct.S_CAL_CAT = cst_holiday AND
626: cs.s_cal_status = ci.CAL_STATUS AND
627: cs.s_cal_status = cst_active AND

Line 636: IGS_CA_STAT cs

632: FROM IGS_CA_TYPE ct
633: WHERE ct.S_CAL_CAT = cst_holiday AND
634: EXISTS (SELECT 'x'
635: FROM IGS_CA_INST ci,
636: IGS_CA_STAT cs
637: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
638: ci.CAL_STATUS = cs.CAL_STATUS AND
639: cs.s_cal_status = cst_active AND
640: EXISTS (SELECT 'x'

Line 746: IGS_CA_STAT cs

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
748: ct.S_CAL_CAT = cst_holiday AND
749: cs.s_cal_status = ci.CAL_STATUS AND
750: cs.s_cal_status = cst_active AND

Line 767: IGS_CA_STAT cs

763: FROM IGS_CA_TYPE ct
764: WHERE ct.S_CAL_CAT = cst_holiday AND
765: EXISTS (SELECT 'x'
766: FROM IGS_CA_INST ci,
767: IGS_CA_STAT cs
768: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
769: ci.CAL_STATUS = cs.CAL_STATUS AND
770: cs.s_cal_status = cst_active AND
771: EXISTS (SELECT 'x'