DBA Data[Home] [Help]

APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PJI_FM_AGGR_FIN7

Line 74: FROM PJI_FM_AGGR_FIN7

70: -1 LAST_UPDATED_BY,
71: sysdate CREATION_DATE,
72: -1 CREATED_BY,
73: -1 LAST_UPDATE_LOGIN
74: FROM PJI_FM_AGGR_FIN7
75: WHERE project_id = p_project_id ) FIN7
76: ON
77: (
78:

Line 326: PJI_FM_AGGR_FIN7 tmp7

322: sysdate CREATION_DATE,
323: -1 CREATED_BY,
324: -1 LAST_UPDATE_LOGIN
325: from
326: PJI_FM_AGGR_FIN7 tmp7
327: where
328: tmp7.PROJECT_ID = p_project_id
329: group by
330: tmp7.TXN_ACCUM_HEADER_ID,

Line 339: delete from PJI_FM_AGGR_FIN7

335: tmp7.RECVR_PERIOD_TYPE,
336: tmp7.RECVR_PERIOD_ID,
337: tmp7.TXN_CURRENCY_CODE;
338:
339: delete from PJI_FM_AGGR_FIN7
340: where project_id = p_project_id;
341: end merge_into_fp_txn_accum;
342:
343:

Line 1136: FROM pji_fm_aggr_fin7 tmp

1132: G2_RAW_COST , G2_BRDN_COST , G2_BILL_RAW_COST ,
1133: G2_BILL_BRDN_COST , G2_REVENUE_WRITEOFF , G2_SUP_INV_COMMITTED_COST ,
1134: G2_PO_COMMITTED_COST , G2_PR_COMMITTED_COST , G2_OTH_COMMITTED_COST ,
1135: ASSIGNMENT_ID , NAMED_ROLE --Bug#4590810
1136: FROM pji_fm_aggr_fin7 tmp
1137: ,pa_proj_fp_options ppfo
1138: WHERE
1139: tmp.PROJECT_ID= p_project_id AND
1140: ppfo.PROJECT_ID=tmp.PROJECT_ID AND