176: sysdate START_DATE,
177: null END_DATE,
178: null COMPLETION_TEXT
179: from
180: dual;
181:
182: end if;
183:
184: end RUN_SETUP;
398: sysdate START_DATE,
399: null END_DATE,
400: null COMPLETION_TEXT
401: from
402: dual;
403:
404: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'P');
405:
406: -- Update list of organizations to be extracted in case
1066: RATE_TYPE
1067: from
1068: PJI_FM_DNGL_FIN tmp2,
1069: (
1070: select 'RECVR_GL1' INVERT_ID from dual union all
1071: select 'RECVR_GL2' INVERT_ID from dual union all
1072: select 'RECVR_PA1' INVERT_ID from dual union all
1073: select 'RECVR_PA2' INVERT_ID from dual
1074: ) invert
1067: from
1068: PJI_FM_DNGL_FIN tmp2,
1069: (
1070: select 'RECVR_GL1' INVERT_ID from dual union all
1071: select 'RECVR_GL2' INVERT_ID from dual union all
1072: select 'RECVR_PA1' INVERT_ID from dual union all
1073: select 'RECVR_PA2' INVERT_ID from dual
1074: ) invert
1075: where
1068: PJI_FM_DNGL_FIN tmp2,
1069: (
1070: select 'RECVR_GL1' INVERT_ID from dual union all
1071: select 'RECVR_GL2' INVERT_ID from dual union all
1072: select 'RECVR_PA1' INVERT_ID from dual union all
1073: select 'RECVR_PA2' INVERT_ID from dual
1074: ) invert
1075: where
1076: tmp2.WORKER_ID = 0
1069: (
1070: select 'RECVR_GL1' INVERT_ID from dual union all
1071: select 'RECVR_GL2' INVERT_ID from dual union all
1072: select 'RECVR_PA1' INVERT_ID from dual union all
1073: select 'RECVR_PA2' INVERT_ID from dual
1074: ) invert
1075: where
1076: tmp2.WORKER_ID = 0
1077: union
1122: RATE_TYPE
1123: from
1124: PJI_FM_DNGL_ACT tmp2,
1125: (
1126: select 'GL1' INVERT_ID from dual union all
1127: select 'GL2' INVERT_ID from dual union all
1128: select 'PA1' INVERT_ID from dual union all
1129: select 'PA2' INVERT_ID from dual
1130: ) invert
1123: from
1124: PJI_FM_DNGL_ACT tmp2,
1125: (
1126: select 'GL1' INVERT_ID from dual union all
1127: select 'GL2' INVERT_ID from dual union all
1128: select 'PA1' INVERT_ID from dual union all
1129: select 'PA2' INVERT_ID from dual
1130: ) invert
1131: where
1124: PJI_FM_DNGL_ACT tmp2,
1125: (
1126: select 'GL1' INVERT_ID from dual union all
1127: select 'GL2' INVERT_ID from dual union all
1128: select 'PA1' INVERT_ID from dual union all
1129: select 'PA2' INVERT_ID from dual
1130: ) invert
1131: where
1132: tmp2.WORKER_ID = 0
1125: (
1126: select 'GL1' INVERT_ID from dual union all
1127: select 'GL2' INVERT_ID from dual union all
1128: select 'PA1' INVERT_ID from dual union all
1129: select 'PA2' INVERT_ID from dual
1130: ) invert
1131: where
1132: tmp2.WORKER_ID = 0
1133: ) tmp2
1217: 'EXP_PA', tmp2.DANGLING_EXP_PA_TIME_FLAG) DANGLING_FLAG
1218: from
1219: PJI_FM_DNGL_FIN tmp2,
1220: (
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1218: from
1219: PJI_FM_DNGL_FIN tmp2,
1220: (
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1219: PJI_FM_DNGL_FIN tmp2,
1220: (
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1220: (
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1229: select 'EXP_PA' INVERT_ID from dual
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1229: select 'EXP_PA' INVERT_ID from dual
1230: ) invert
1223: select 'EXP_EN' INVERT_ID from dual union all
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1229: select 'EXP_PA' INVERT_ID from dual
1230: ) invert
1231: where
1224: select 'PRVDR_GL' INVERT_ID from dual union all
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1229: select 'EXP_PA' INVERT_ID from dual
1230: ) invert
1231: where
1232: tmp2.WORKER_ID = 0
1225: select 'RECVR_GL' INVERT_ID from dual union all
1226: select 'EXP_GL' INVERT_ID from dual union all
1227: select 'PRVDR_PA' INVERT_ID from dual union all
1228: select 'RECVR_PA' INVERT_ID from dual union all
1229: select 'EXP_PA' INVERT_ID from dual
1230: ) invert
1231: where
1232: tmp2.WORKER_ID = 0
1233: union
1252: 'PA', tmp2.DANGLING_PA_TIME_FLAG) DANGLING_FLAG
1253: from
1254: PJI_FM_DNGL_ACT tmp2,
1255: (
1256: select 'EN' INVERT_ID from dual union all
1257: select 'GL' INVERT_ID from dual union all
1258: select 'PA' INVERT_ID from dual
1259: ) invert
1260: where
1253: from
1254: PJI_FM_DNGL_ACT tmp2,
1255: (
1256: select 'EN' INVERT_ID from dual union all
1257: select 'GL' INVERT_ID from dual union all
1258: select 'PA' INVERT_ID from dual
1259: ) invert
1260: where
1261: tmp2.WORKER_ID = 0
1254: PJI_FM_DNGL_ACT tmp2,
1255: (
1256: select 'EN' INVERT_ID from dual union all
1257: select 'GL' INVERT_ID from dual union all
1258: select 'PA' INVERT_ID from dual
1259: ) invert
1260: where
1261: tmp2.WORKER_ID = 0
1262: ) tmp2