eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_GEN_004 dependencies on IGS_CA_DA_INST

Line 198: igs_ca_da_inst_v cv

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
202: ci.cal_status = cs.cal_status AND

Line 1073: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;

1069: v_mod_count NUMBER(5);
1070: v_constraint_count NUMBER(5);
1071: v_loop_count NUMBER(5);
1072: v_message_name varchar2(30);
1073: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
1074:
1075:
1076: v_msg_name VARCHAR2(30);
1077: v_changed BOOLEAN;

Line 1117: FROM IGS_CA_DA_INST dai,

1113: v_min_alias_val DATE DEFAULT NULL;
1114:
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

Line 1128: cp_date_val IGS_CA_DA_INST.absolute_val%TYPE) IS

1124: cs.s_cal_status = cst_active AND
1125: dai.CAL_TYPE = ci.CAL_TYPE;
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'

Line 1139: FROM IGS_CA_DA_INST dai

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'
1139: FROM IGS_CA_DA_INST dai
1140: WHERE dai.CAL_TYPE = ct.CAL_TYPE AND
1141: TRUNC(dai.absolute_val)= cp_date_val));
1142: BEGIN
1143: OPEN c_m_alias_val;

Line 1233: FROM IGS_CA_DA_INST dai1,

1229: v_min_alias_val DATE DEFAULT NULL;
1230:
1231: CURSOR c_m_alias_val2 IS
1232: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
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,

Line 1234: IGS_CA_DA_INST dai2,

1230:
1231: CURSOR c_m_alias_val2 IS
1232: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
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

Line 1235: IGS_CA_DA_INST_PAIR daip,

1231: CURSOR c_m_alias_val2 IS
1232: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
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

Line 1254: cp_date_val IGS_CA_DA_INST.absolute_val%TYPE) IS

1250: dai2.CAL_TYPE = daip.related_cal_type AND
1251: dai2.ci_sequence_number = daip.related_ci_sequence_number;
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'

Line 1265: FROM IGS_CA_DA_INST dai1,

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'
1265: FROM IGS_CA_DA_INST dai1,
1266: IGS_CA_DA_INST dai2,
1267: IGS_CA_DA_INST_PAIR daip
1268: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
1269: dai1.DT_ALIAS = daip.DT_ALIAS AND

Line 1266: IGS_CA_DA_INST dai2,

1262: ci.CAL_STATUS = cs.CAL_STATUS AND
1263: cs.s_cal_status = cst_active AND
1264: EXISTS (SELECT 'x'
1265: FROM IGS_CA_DA_INST dai1,
1266: IGS_CA_DA_INST dai2,
1267: IGS_CA_DA_INST_PAIR daip
1268: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
1269: dai1.DT_ALIAS = daip.DT_ALIAS AND
1270: dai1.sequence_number = daip.dai_sequence_number AND

Line 1267: IGS_CA_DA_INST_PAIR daip

1263: cs.s_cal_status = cst_active AND
1264: EXISTS (SELECT 'x'
1265: FROM IGS_CA_DA_INST dai1,
1266: IGS_CA_DA_INST dai2,
1267: IGS_CA_DA_INST_PAIR daip
1268: WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
1269: dai1.DT_ALIAS = daip.DT_ALIAS AND
1270: dai1.sequence_number = daip.dai_sequence_number AND
1271: dai1.CAL_TYPE = daip.CAL_TYPE AND

Line 2300: FROM igs_ca_da_inst ai,

2296:
2297: CURSOR c_cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
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