DBA Data[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 2151: PJI_PJP_PROJ_BATCH_MAP map,

2147: to_number(null) G2_OTH_COMMITTED_COST,
2148: bal.QUANTITY,
2149: bal.BILL_QUANTITY
2150: from
2151: PJI_PJP_PROJ_BATCH_MAP map,
2152: PJI_FP_TXN_ACCUM bal,
2153: PJI_PJP_RBS_HEADER rbs_hdr
2154: where
2155: p_extraction_type in ('FULL', 'PARTIAL') and

Line 2229: PJI_PJP_PROJ_BATCH_MAP map,

2225: bal.G2_OTH_COMMITTED_COST,
2226: to_number(null) QUANTITY,
2227: to_number(null) BILL_QUANTITY
2228: from
2229: PJI_PJP_PROJ_BATCH_MAP map,
2230: PJI_FP_TXN_ACCUM1 bal,
2231: PJI_PJP_RBS_HEADER rbs_hdr
2232: where
2233: p_extraction_type in ('FULL', 'PARTIAL') and

Line 2658: PJI_PJP_PROJ_BATCH_MAP map,

2654: src1.TXN_CURRENCY_CODE
2655: ) src2
2656: ) src,
2657: PA_RBS_TXN_ACCUM_MAP rbs,
2658: PJI_PJP_PROJ_BATCH_MAP map,
2659: PJI_ORG_EXTR_INFO info,
2660: PJI_PJP_WBS_HEADER wbs_hdr,
2661: PA_PROJ_ELEMENT_VERSIONS ver,
2662: (

Line 4326: PJI_PJP_PROJ_BATCH_MAP map,

4322: 'LW', 'Y',
4323: 'LF', 'N') WP_FLAG,
4324: 'Y' PUSHUP_FLAG
4325: from
4326: PJI_PJP_PROJ_BATCH_MAP map,
4327: PJI_XBS_DENORM prg,
4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 5641: PJI_PJP_PROJ_BATCH_MAP map,

5637: 'LW', 'Y',
5638: 'LF', 'N') WP_FLAG,
5639: 'Y' PUSHUP_FLAG
5640: from
5641: PJI_PJP_PROJ_BATCH_MAP map,
5642: PJI_XBS_DENORM prg,
5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 6956: PJI_PJP_PROJ_BATCH_MAP map,

6952: 'LW', 'Y',
6953: 'LF', 'N') WP_FLAG,
6954: 'Y' PUSHUP_FLAG
6955: from
6956: PJI_PJP_PROJ_BATCH_MAP map,
6957: PJI_XBS_DENORM prg,
6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 8270: PJI_PJP_PROJ_BATCH_MAP map,

8266: 'LW', 'Y',
8267: 'LF', 'N') WP_FLAG,
8268: 'Y' PUSHUP_FLAG
8269: from
8270: PJI_PJP_PROJ_BATCH_MAP map,
8271: PJI_XBS_DENORM prg,
8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 9584: PJI_PJP_PROJ_BATCH_MAP map,

9580: 'LW', 'Y',
9581: 'LF', 'N') WP_FLAG,
9582: 'Y' PUSHUP_FLAG
9583: from
9584: PJI_PJP_PROJ_BATCH_MAP map,
9585: PJI_XBS_DENORM prg,
9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 10898: PJI_PJP_PROJ_BATCH_MAP map,

10894: 'LW', 'Y',
10895: 'LF', 'N') WP_FLAG,
10896: 'Y' PUSHUP_FLAG
10897: from
10898: PJI_PJP_PROJ_BATCH_MAP map,
10899: PJI_XBS_DENORM prg,
10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 12212: PJI_PJP_PROJ_BATCH_MAP map,

12208: 'LW', 'Y',
12209: 'LF', 'N') WP_FLAG,
12210: 'Y' PUSHUP_FLAG
12211: from
12212: PJI_PJP_PROJ_BATCH_MAP map,
12213: PJI_XBS_DENORM prg,
12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 13526: PJI_PJP_PROJ_BATCH_MAP map,

13522: 'LW', 'Y',
13523: 'LF', 'N') WP_FLAG,
13524: 'Y' PUSHUP_FLAG
13525: from
13526: PJI_PJP_PROJ_BATCH_MAP map,
13527: PJI_XBS_DENORM prg,
13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 14840: PJI_PJP_PROJ_BATCH_MAP map,

14836: 'LW', 'Y',
14837: 'LF', 'N') WP_FLAG,
14838: 'Y' PUSHUP_FLAG
14839: from
14840: PJI_PJP_PROJ_BATCH_MAP map,
14841: PJI_XBS_DENORM prg,
14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 16154: PJI_PJP_PROJ_BATCH_MAP map,

16150: 'LW', 'Y',
16151: 'LF', 'N') WP_FLAG,
16152: 'Y' PUSHUP_FLAG
16153: from
16154: PJI_PJP_PROJ_BATCH_MAP map,
16155: PJI_XBS_DENORM prg,
16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all