DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_AC_XBS_ACCUM_F

Line 7878: INSERT INTO PJI_AC_XBS_ACCUM_F

7874: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7875: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7876: BEGIN
7877:
7878: INSERT INTO PJI_AC_XBS_ACCUM_F
7879: (
7880: PROJECT_ID
7881: , PROJECT_ORG_ID
7882: , PROJECT_ORGANIZATION_ID

Line 8072: , PJI_AC_XBS_ACCUM_F rl

8068: , tmp.ROWID PJP1_ROWID
8069: , rl.ROWID FPR_ROWID
8070: FROM
8071: PJI_AC_AGGR_PJP1_T tmp
8072: , PJI_AC_XBS_ACCUM_F rl
8073: WHERE 1 = 1
8074: AND tmp.worker_id = g_worker_id
8075: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
8076: AND tmp.PROJECT_ORG_ID = rl.PROJECT_ORG_ID (+)

Line 8104: PJI_AC_XBS_ACCUM_F rl

8100:
8101: BEGIN
8102:
8103: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
8104: PJI_AC_XBS_ACCUM_F rl
8105: SET (
8106: rl.REVENUE
8107: , rl.INITIAL_FUNDING_AMOUNT
8108: , rl.INITIAL_FUNDING_COUNT

Line 8242: INSERT INTO PJI_AC_XBS_ACCUM_F

8238: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8239: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8240: BEGIN
8241:
8242: INSERT INTO PJI_AC_XBS_ACCUM_F
8243: (
8244: PROJECT_ID
8245: , PROJECT_ORG_ID
8246: , PROJECT_ORGANIZATION_ID