APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_AC_RMAP_ACR

Line 7374: DELETE FROM PJI_AC_RMAP_ACR

7370:
7371: PROCEDURE CLEANUP_AC_RMAP_FPR IS
7372: BEGIN
7373:
7374: DELETE FROM PJI_AC_RMAP_ACR
7375: WHERE worker_id = g_worker_id;
7376:
7377: EXCEPTION
7378: WHEN OTHERS THEN

Line 7388: INSERT INTO PJI_AC_RMAP_ACR /*Not decided to keep this hint yet. + APPEND PARALLEL */

7384:
7385: PROCEDURE GET_AC_ROW_IDS IS
7386: BEGIN
7387:
7388: INSERT INTO PJI_AC_RMAP_ACR /*Not decided to keep this hint yet. + APPEND PARALLEL */
7389: (
7390: worker_id
7391: , rl_rowid
7392: , tmp_rowid

Line 7486: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_AC_RMAP_ACR_N1) */

7482: , rl.LAST_UPDATED_BY
7483: , rl.LAST_UPDATE_LOGIN
7484: ) =
7485: (
7486: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_AC_RMAP_ACR_N1) */
7487: NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
7488: , NVL(rl.INITIAL_FUNDING_AMOUNT, 0) + NVL(tmp.INITIAL_FUNDING_AMOUNT, 0)
7489: , NVL(rl.INITIAL_FUNDING_COUNT, 0) + NVL(tmp.INITIAL_FUNDING_COUNT, 0)
7490: , NVL(rl.ADDITIONAL_FUNDING_AMOUNT, 0) + NVL(tmp.ADDITIONAL_FUNDING_AMOUNT, 0)

Line 7538: PJI_AC_RMAP_ACR rwid

7534: , l_last_update_date
7535: , l_last_updated_by
7536: , l_last_update_login
7537: FROM
7538: PJI_AC_RMAP_ACR rwid
7539: , pji_ac_aggr_pjp1 tmp
7540: WHERE 1 = 1
7541: AND tmp.worker_id = g_worker_id
7542: AND rwid.worker_id = g_worker_id

Line 7549: FROM PJI_AC_RMAP_ACR rwid

7545: AND rwid.rl_rowid IS NOT NULL
7546: )
7547: WHERE rl.rowid IN
7548: ( SELECT rl_rowid
7549: FROM PJI_AC_RMAP_ACR rwid
7550: WHERE 1=1
7551: AND rwid.rl_rowid IS NOT NULL
7552: AND rwid.worker_id = g_worker_id);
7553:

Line 7701: , PJI_AC_RMAP_ACR rwid

7697: , CUSTOM13
7698: , CUSTOM14
7699: , CUSTOM15
7700: FROM pji_ac_aggr_pjp1 tmp
7701: , PJI_AC_RMAP_ACR rwid
7702: WHERE 1 = 1
7703: AND tmp.worker_id = g_worker_id
7704: AND rwid.worker_id = g_worker_id
7705: AND tmp.rowid = rwid.tmp_rowid