APPS.PJI_FM_SUM_PSI dependencies on PJI_PJP_RMAP_FPR

Line 3675: insert into PJI_PJP_RMAP_FPR psi_i

3671:
3672: if (l_extraction_type = 'INCREMENTAL') then
3673:
3674: -- Actuals
3675: insert into PJI_PJP_RMAP_FPR psi_i
3676: (
3677: WORKER_ID,
3678: STG_ROWID,
3679: TXN_ROWID,

Line 3709: insert into PJI_PJP_RMAP_FPR psi_i

3705: tmp7.RECVR_PERIOD_ID = psi.RECVR_PERIOD_ID (+) and
3706: tmp7.TXN_CURRENCY_CODE = psi.TXN_CURRENCY_CODE (+);
3707:
3708: -- coMmitments
3709: insert into PJI_PJP_RMAP_FPR psi_i
3710: (
3711: WORKER_ID,
3712: STG_ROWID,
3713: TXN_ROWID,

Line 3811: (select /*+ ordered index(tmp7_r, PJI_PJP_RMAP_FPR_N1) rowid(tmp7) */

3807: BILL_QUANTITY,
3808: LAST_UPDATE_DATE,
3809: LAST_UPDATED_BY,
3810: LAST_UPDATE_LOGIN) =
3811: (select /*+ ordered index(tmp7_r, PJI_PJP_RMAP_FPR_N1) rowid(tmp7) */
3812: decode(nvl(psi.TXN_RAW_COST, 0) + nvl(sum(tmp7.TXN_RAW_COST), 0),
3813: 0, null,
3814: nvl(psi.TXN_RAW_COST, 0) + nvl(sum(tmp7.TXN_RAW_COST), 0)),
3815: decode(nvl(psi.TXN_BILL_RAW_COST, 0) + nvl(sum(tmp7.TXN_BILL_RAW_COST), 0),

Line 3909: PJI_PJP_RMAP_FPR tmp7_r,

3905: l_last_update_date,
3906: l_last_updated_by,
3907: l_last_update_login
3908: from
3909: PJI_PJP_RMAP_FPR tmp7_r,
3910: PJI_FM_AGGR_FIN7 tmp7
3911: where
3912: tmp7_r.WORKER_ID = p_worker_id and
3913: tmp7_r.RECORD_TYPE = 'A' and

Line 3918: (select /*+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) */

3914: tmp7_r.TXN_ROWID is not null and
3915: tmp7.ROWID = tmp7_r.STG_ROWID and
3916: psi.ROWID = tmp7_r.TXN_ROWID)
3917: where psi.ROWID in
3918: (select /*+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) */
3919: tmp7_r.TXN_ROWID
3920: from
3921: PJI_PJP_RMAP_FPR tmp7_r
3922: where

Line 3921: PJI_PJP_RMAP_FPR tmp7_r

3917: where psi.ROWID in
3918: (select /*+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) */
3919: tmp7_r.TXN_ROWID
3920: from
3921: PJI_PJP_RMAP_FPR tmp7_r
3922: where
3923: tmp7_r.WORKER_ID = p_worker_id and
3924: tmp7_r.RECORD_TYPE = 'A' and
3925: tmp7_r.TXN_ROWID is not null);

Line 4080: PJI_PJP_RMAP_FPR tmp7_r,

4076: l_creation_date CREATION_DATE,
4077: l_created_by CREATED_BY,
4078: l_last_update_login LAST_UPDATE_LOGIN
4079: from
4080: PJI_PJP_RMAP_FPR tmp7_r,
4081: PJI_FM_AGGR_FIN7 tmp7
4082: where
4083: tmp7_r.WORKER_ID = p_worker_id and
4084: tmp7_r.TXN_ROWID is null and

Line 4142: from PJI_PJP_RMAP_FPR

4138: if (l_extraction_type = 'INCREMENTAL') then
4139:
4140: delete from PJI_FM_AGGR_FIN7
4141: where ROWID in (select STG_ROWID
4142: from PJI_PJP_RMAP_FPR
4143: where WORKER_ID = p_worker_id);
4144:
4145: end if;
4146:

Line 4188: from PJI_PJP_RMAP_FPR tmp7_r,

4184: delete
4185: from PJI_FP_TXN_ACCUM1 bal
4186: where bal.PROJECT_ID in (select distinct
4187: fin7.PROJECT_ID
4188: from PJI_PJP_RMAP_FPR tmp7_r,
4189: PJI_FM_AGGR_FIN7 fin7
4190: where tmp7_r.WORKER_ID = p_worker_id and
4191: tmp7_r.RECORD_TYPE = 'M' and
4192: fin7.ROWID = tmp7_r.STG_ROWID);

Line 4324: PJI_PJP_RMAP_FPR tmp7_r,

4320: l_creation_date CREATION_DATE,
4321: l_created_by CREATED_BY,
4322: l_last_update_login LAST_UPDATE_LOGIN
4323: from
4324: PJI_PJP_RMAP_FPR tmp7_r,
4325: PJI_FM_AGGR_FIN7 tmp7
4326: where
4327: tmp7_r.WORKER_ID = p_worker_id and
4328: tmp7_r.TXN_ROWID is null and