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.PJI_FM_SUM_MAIN dependencies on DUAL

Line 180: dual;

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;

Line 402: dual;

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

Line 1070: select 'RECVR_GL1' INVERT_ID from dual union all

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

Line 1071: select 'RECVR_GL2' INVERT_ID from dual union all

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

Line 1072: select 'RECVR_PA1' INVERT_ID from dual union all

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

Line 1073: select 'RECVR_PA2' INVERT_ID from dual

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

Line 1126: select 'GL1' INVERT_ID from dual union all

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

Line 1127: select 'GL2' INVERT_ID from dual union all

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

Line 1128: select 'PA1' INVERT_ID from dual union all

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

Line 1129: select 'PA2' INVERT_ID from dual

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

Line 1221: select 'PRVDR_EN' INVERT_ID from dual union all

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

Line 1222: select 'RECVR_EN' 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

Line 1223: select 'EXP_EN' 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

Line 1224: select 'PRVDR_GL' 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

Line 1225: select 'RECVR_GL' 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

Line 1226: select 'EXP_GL' 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
1230: ) invert

Line 1227: select 'PRVDR_PA' 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
1231: where

Line 1228: select 'RECVR_PA' 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
1232: tmp2.WORKER_ID = 0

Line 1229: select 'EXP_PA' INVERT_ID from dual

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

Line 1256: select 'EN' INVERT_ID from dual union all

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

Line 1257: select 'GL' INVERT_ID from dual union all

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

Line 1258: select 'PA' INVERT_ID from dual

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