DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_AC_XBS_ACCUM_F

Line 7206: INSERT INTO PJI_AC_XBS_ACCUM_F

7202: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7203: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7204: BEGIN
7205:
7206: INSERT INTO PJI_AC_XBS_ACCUM_F
7207: (
7208: PROJECT_ID
7209: , PROJECT_ORG_ID
7210: , PROJECT_ORGANIZATION_ID

Line 7400: , PJI_AC_XBS_ACCUM_F rl

7396: , rl.ROWID pjp1_rowid
7397: , tmp.ROWID TMP1_ROWID
7398: FROM
7399: pji_ac_aggr_pjp1 tmp
7400: , PJI_AC_XBS_ACCUM_F rl
7401: WHERE 1 = 1
7402: AND tmp.worker_id = g_worker_id
7403: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
7404: AND tmp.PROJECT_ORG_ID = rl.PROJECT_ORG_ID (+)

Line 7432: PJI_AC_XBS_ACCUM_F rl

7428:
7429: BEGIN
7430:
7431: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
7432: PJI_AC_XBS_ACCUM_F rl
7433: SET (
7434: rl.REVENUE
7435: , rl.INITIAL_FUNDING_AMOUNT
7436: , rl.INITIAL_FUNDING_COUNT

Line 7570: INSERT INTO PJI_AC_XBS_ACCUM_F

7566: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7567: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7568: BEGIN
7569:
7570: INSERT INTO PJI_AC_XBS_ACCUM_F
7571: (
7572: PROJECT_ID
7573: , PROJECT_ORG_ID
7574: , PROJECT_ORGANIZATION_ID