DBA Data[Home] [Help]

APPS.PJI_FM_SUM_MAIN dependencies on DUAL

Line 181: dual;

177: sysdate START_DATE,
178: null END_DATE,
179: null COMPLETION_TEXT
180: from
181: dual;
182:
183: end if;
184:
185: end RUN_SETUP;

Line 403: dual;

399: sysdate START_DATE,
400: null END_DATE,
401: null COMPLETION_TEXT
402: from
403: dual;
404:
405: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'P');
406:
407: -- Update list of organizations to be extracted in case

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

1067: RATE_TYPE
1068: from
1069: PJI_FM_DNGL_FIN tmp2,
1070: (
1071: select 'RECVR_GL1' INVERT_ID from dual union all
1072: select 'RECVR_GL2' INVERT_ID from dual union all
1073: select 'RECVR_PA1' INVERT_ID from dual union all
1074: select 'RECVR_PA2' INVERT_ID from dual
1075: ) invert

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

1068: from
1069: PJI_FM_DNGL_FIN tmp2,
1070: (
1071: select 'RECVR_GL1' INVERT_ID from dual union all
1072: select 'RECVR_GL2' INVERT_ID from dual union all
1073: select 'RECVR_PA1' INVERT_ID from dual union all
1074: select 'RECVR_PA2' INVERT_ID from dual
1075: ) invert
1076: where

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

1069: PJI_FM_DNGL_FIN tmp2,
1070: (
1071: select 'RECVR_GL1' INVERT_ID from dual union all
1072: select 'RECVR_GL2' INVERT_ID from dual union all
1073: select 'RECVR_PA1' INVERT_ID from dual union all
1074: select 'RECVR_PA2' INVERT_ID from dual
1075: ) invert
1076: where
1077: tmp2.WORKER_ID = 0

Line 1074: select 'RECVR_PA2' INVERT_ID from dual

1070: (
1071: select 'RECVR_GL1' INVERT_ID from dual union all
1072: select 'RECVR_GL2' INVERT_ID from dual union all
1073: select 'RECVR_PA1' INVERT_ID from dual union all
1074: select 'RECVR_PA2' INVERT_ID from dual
1075: ) invert
1076: where
1077: tmp2.WORKER_ID = 0
1078: union

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

1123: RATE_TYPE
1124: from
1125: PJI_FM_DNGL_ACT tmp2,
1126: (
1127: select 'GL1' INVERT_ID from dual union all
1128: select 'GL2' INVERT_ID from dual union all
1129: select 'PA1' INVERT_ID from dual union all
1130: select 'PA2' INVERT_ID from dual
1131: ) invert

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

1124: from
1125: PJI_FM_DNGL_ACT tmp2,
1126: (
1127: select 'GL1' INVERT_ID from dual union all
1128: select 'GL2' INVERT_ID from dual union all
1129: select 'PA1' INVERT_ID from dual union all
1130: select 'PA2' INVERT_ID from dual
1131: ) invert
1132: where

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

1125: PJI_FM_DNGL_ACT tmp2,
1126: (
1127: select 'GL1' INVERT_ID from dual union all
1128: select 'GL2' INVERT_ID from dual union all
1129: select 'PA1' INVERT_ID from dual union all
1130: select 'PA2' INVERT_ID from dual
1131: ) invert
1132: where
1133: tmp2.WORKER_ID = 0

Line 1130: select 'PA2' INVERT_ID from dual

1126: (
1127: select 'GL1' INVERT_ID from dual union all
1128: select 'GL2' INVERT_ID from dual union all
1129: select 'PA1' INVERT_ID from dual union all
1130: select 'PA2' INVERT_ID from dual
1131: ) invert
1132: where
1133: tmp2.WORKER_ID = 0
1134: ) tmp2

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

1218: 'EXP_PA', tmp2.DANGLING_EXP_PA_TIME_FLAG) DANGLING_FLAG
1219: from
1220: PJI_FM_DNGL_FIN tmp2,
1221: (
1222: select 'PRVDR_EN' INVERT_ID from dual union all
1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all

Line 1223: select 'RECVR_EN' INVERT_ID from dual union all

1219: from
1220: PJI_FM_DNGL_FIN tmp2,
1221: (
1222: select 'PRVDR_EN' INVERT_ID from dual union all
1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all

Line 1224: select 'EXP_EN' INVERT_ID from dual union all

1220: PJI_FM_DNGL_FIN tmp2,
1221: (
1222: select 'PRVDR_EN' INVERT_ID from dual union all
1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all

Line 1225: select 'PRVDR_GL' INVERT_ID from dual union all

1221: (
1222: select 'PRVDR_EN' INVERT_ID from dual union all
1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all

Line 1226: select 'RECVR_GL' INVERT_ID from dual union all

1222: select 'PRVDR_EN' INVERT_ID from dual union all
1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all
1230: select 'EXP_PA' INVERT_ID from dual

Line 1227: select 'EXP_GL' INVERT_ID from dual union all

1223: select 'RECVR_EN' INVERT_ID from dual union all
1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all
1230: select 'EXP_PA' INVERT_ID from dual
1231: ) invert

Line 1228: select 'PRVDR_PA' INVERT_ID from dual union all

1224: select 'EXP_EN' INVERT_ID from dual union all
1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all
1230: select 'EXP_PA' INVERT_ID from dual
1231: ) invert
1232: where

Line 1229: select 'RECVR_PA' INVERT_ID from dual union all

1225: select 'PRVDR_GL' INVERT_ID from dual union all
1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all
1230: select 'EXP_PA' INVERT_ID from dual
1231: ) invert
1232: where
1233: tmp2.WORKER_ID = 0

Line 1230: select 'EXP_PA' INVERT_ID from dual

1226: select 'RECVR_GL' INVERT_ID from dual union all
1227: select 'EXP_GL' INVERT_ID from dual union all
1228: select 'PRVDR_PA' INVERT_ID from dual union all
1229: select 'RECVR_PA' INVERT_ID from dual union all
1230: select 'EXP_PA' INVERT_ID from dual
1231: ) invert
1232: where
1233: tmp2.WORKER_ID = 0
1234: union

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

1253: 'PA', tmp2.DANGLING_PA_TIME_FLAG) DANGLING_FLAG
1254: from
1255: PJI_FM_DNGL_ACT tmp2,
1256: (
1257: select 'EN' INVERT_ID from dual union all
1258: select 'GL' INVERT_ID from dual union all
1259: select 'PA' INVERT_ID from dual
1260: ) invert
1261: where

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

1254: from
1255: PJI_FM_DNGL_ACT tmp2,
1256: (
1257: select 'EN' INVERT_ID from dual union all
1258: select 'GL' INVERT_ID from dual union all
1259: select 'PA' INVERT_ID from dual
1260: ) invert
1261: where
1262: tmp2.WORKER_ID = 0

Line 1259: select 'PA' INVERT_ID from dual

1255: PJI_FM_DNGL_ACT tmp2,
1256: (
1257: select 'EN' INVERT_ID from dual union all
1258: select 'GL' INVERT_ID from dual union all
1259: select 'PA' INVERT_ID from dual
1260: ) invert
1261: where
1262: tmp2.WORKER_ID = 0
1263: ) tmp2