[Home] [Help]
193: DISTINCT cv.alias_val
194: FROM
195: igs_ca_inst ci,
196: igs_ca_type ct,
197: igs_ca_stat cs,
198: igs_ca_da_inst_v cv
199: WHERE
200: ci.cal_type = ct.cal_type AND
201: ct.s_cal_cat = 'HOLIDAY' AND
1116: SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
1117: FROM IGS_CA_DA_INST dai,
1118: IGS_CA_INST ci,
1119: IGS_CA_TYPE ct,
1120: IGS_CA_STAT cs
1121: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1122: ct.S_CAL_CAT = cst_holiday AND
1123: cs.s_cal_status = ci.CAL_STATUS AND
1124: cs.s_cal_status = cst_active AND
1130: FROM IGS_CA_TYPE ct
1131: WHERE ct.S_CAL_CAT = cst_holiday AND
1132: EXISTS (SELECT 'x'
1133: FROM IGS_CA_INST ci,
1134: IGS_CA_STAT cs
1135: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1136: ci.CAL_STATUS = cs.CAL_STATUS AND
1137: cs.s_cal_status = cst_active AND
1138: EXISTS (SELECT 'x'
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
1240: ct.S_CAL_CAT = cst_holiday AND
1241: cs.cal_status = ci.CAL_STATUS AND
1242: cs.s_cal_status = cst_active AND
1256: FROM IGS_CA_TYPE ct
1257: WHERE ct.S_CAL_CAT = cst_holiday AND
1258: EXISTS (SELECT 'x'
1259: FROM IGS_CA_INST ci,
1260: IGS_CA_STAT cs
1261: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1262: ci.CAL_STATUS = cs.CAL_STATUS AND
1263: cs.s_cal_status = cst_active AND
1264: EXISTS (SELECT 'x'
2299: SELECT DISTINCT ai.absolute_val
2300: FROM igs_ca_da_inst ai,
2301: igs_ca_inst_all ci,
2302: igs_ca_type ct,
2303: igs_ca_stat cs
2304: WHERE ai.cal_type = ci.cal_type
2305: AND ai.ci_sequence_number = ci.sequence_number
2306: AND ci.cal_type = ct.cal_type
2307: AND ct.s_cal_cat = 'HOLIDAY'