DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_AC_XBS_ACCUM_F

Line 7730: INSERT INTO PJI_AC_XBS_ACCUM_F

7726: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7727: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7728: BEGIN
7729:
7730: INSERT INTO PJI_AC_XBS_ACCUM_F
7731: (
7732: PROJECT_ID
7733: , PROJECT_ORG_ID
7734: , PROJECT_ORGANIZATION_ID

Line 7924: , PJI_AC_XBS_ACCUM_F rl

7920: , tmp.ROWID PJP1_ROWID
7921: , rl.ROWID FPR_ROWID
7922: FROM
7923: PJI_AC_AGGR_PJP1_T tmp
7924: , PJI_AC_XBS_ACCUM_F rl
7925: WHERE 1 = 1
7926: AND tmp.worker_id = g_worker_id
7927: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
7928: AND tmp.PROJECT_ORG_ID = rl.PROJECT_ORG_ID (+)

Line 7956: PJI_AC_XBS_ACCUM_F rl

7952:
7953: BEGIN
7954:
7955: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
7956: PJI_AC_XBS_ACCUM_F rl
7957: SET (
7958: rl.REVENUE
7959: , rl.INITIAL_FUNDING_AMOUNT
7960: , rl.INITIAL_FUNDING_COUNT

Line 8094: INSERT INTO PJI_AC_XBS_ACCUM_F

8090: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8091: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8092: BEGIN
8093:
8094: INSERT INTO PJI_AC_XBS_ACCUM_F
8095: (
8096: PROJECT_ID
8097: , PROJECT_ORG_ID
8098: , PROJECT_ORGANIZATION_ID