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_PJP_PRG_PERF_ALL dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 5661: PJI_PJP_PROJ_BATCH_MAP map,

5657: select
5658: map.worker_id,bv.project_id,bv.budget_version_id,
5659: nvl(fpo.all_time_phased_code,nvl(fpo.cost_time_phased_code,fpo.revenue_time_phased_code)) time_phased_code
5660: from
5661: PJI_PJP_PROJ_BATCH_MAP map,
5662: PA_PROJ_FP_OPTIONS fpo,
5663: PA_BUDGET_VERSIONS bv
5664: where
5665: map.WORKER_ID = p_worker_id and

Line 5709: PJI_PJP_PROJ_BATCH_MAP map,

5705: UNION ALL --Pull Reversals for Actuals , CB,CO when l_refresh_code=-1,-3,-4
5706: select
5707: map.worker_id,map.project_id, plan_version_id, 'G' time_phased_code
5708: from
5709: PJI_PJP_PROJ_BATCH_MAP map,
5710: (
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual

Line 6112: PJI_PJP_PROJ_BATCH_MAP map,

6108: - fpr.custom13 CUSTOM13,
6109: - fpr.custom14 CUSTOM14,
6110: - fpr.custom15 CUSTOM15 /* Modified for Bug 8271578 End */
6111: from
6112: PJI_PJP_PROJ_BATCH_MAP map,
6113: PJI_FP_XBS_ACCUM_F fpr
6114: where
6115: l_extraction_type = 'INCREMENTAL' and
6116: map.WORKER_ID = p_worker_id and

Line 6371: PJI_PJP_PROJ_BATCH_MAP map,

6367: nvl(max(den.SUP_LEVEL), 0)
6368: into
6369: l_level
6370: from
6371: PJI_PJP_PROJ_BATCH_MAP map,
6372: PJI_XBS_DENORM den
6373: where
6374: map.WORKER_ID = p_worker_id and
6375: den.STRUCT_TYPE = 'PRG' and

Line 8031: PJI_PJP_PROJ_BATCH_MAP map,

8027: 'LW', 'Y',
8028: 'LF', 'N') WP_FLAG,
8029: 'Y' PUSHUP_FLAG
8030: from
8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 9525: PJI_PJP_PROJ_BATCH_MAP map,

9521: 'LW', 'Y',
9522: 'LF', 'N') WP_FLAG,
9523: 'Y' PUSHUP_FLAG
9524: from
9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 11019: PJI_PJP_PROJ_BATCH_MAP map,

11015: 'LW', 'Y',
11016: 'LF', 'N') WP_FLAG,
11017: 'Y' PUSHUP_FLAG
11018: from
11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 12512: PJI_PJP_PROJ_BATCH_MAP map,

12508: 'LW', 'Y',
12509: 'LF', 'N') WP_FLAG,
12510: 'Y' PUSHUP_FLAG
12511: from
12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 14006: PJI_PJP_PROJ_BATCH_MAP map,

14002: 'LW', 'Y',
14003: 'LF', 'N') WP_FLAG,
14004: 'Y' PUSHUP_FLAG
14005: from
14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 15499: PJI_PJP_PROJ_BATCH_MAP map,

15495: 'LW', 'Y',
15496: 'LF', 'N') WP_FLAG,
15497: 'Y' PUSHUP_FLAG
15498: from
15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 16992: PJI_PJP_PROJ_BATCH_MAP map,

16988: 'LW', 'Y',
16989: 'LF', 'N') WP_FLAG,
16990: 'Y' PUSHUP_FLAG
16991: from
16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 18486: PJI_PJP_PROJ_BATCH_MAP map,

18482: 'LW', 'Y',
18483: 'LF', 'N') WP_FLAG,
18484: 'Y' PUSHUP_FLAG
18485: from
18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 19980: PJI_PJP_PROJ_BATCH_MAP map,

19976: 'LW', 'Y',
19977: 'LF', 'N') WP_FLAG,
19978: 'Y' PUSHUP_FLAG
19979: from
19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

Line 21474: PJI_PJP_PROJ_BATCH_MAP map,

21470: 'LW', 'Y',
21471: 'LF', 'N') WP_FLAG,
21472: 'Y' PUSHUP_FLAG
21473: from
21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all