APPS.IGS_PS_GEN_004 dependencies on IGS_CA_TYPE

Line 196: igs_ca_type ct,

192: SELECT
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

Line 1119: IGS_CA_TYPE ct,

1115: CURSOR c_m_alias_val IS
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

Line 1130: FROM IGS_CA_TYPE ct

1126:
1127: CURSOR c_holiday (
1128: cp_date_val IGS_CA_DA_INST.absolute_val%TYPE) IS
1129: SELECT 'x'
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

Line 1237: IGS_CA_TYPE ct,

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
1240: ct.S_CAL_CAT = cst_holiday AND
1241: cs.cal_status = ci.CAL_STATUS AND

Line 1256: FROM IGS_CA_TYPE ct

1252:
1253: CURSOR c_instbreak (
1254: cp_date_val IGS_CA_DA_INST.absolute_val%TYPE) IS
1255: SELECT 'x'
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

Line 2302: igs_ca_type ct,

2298: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
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