APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_AC_RMAP_ACR_T

Line 8046: DELETE FROM PJI_ac_RMAP_acR_T

8042:
8043: PROCEDURE CLEANUP_AC_RMAP_FPR IS
8044: BEGIN
8045:
8046: DELETE FROM PJI_ac_RMAP_acR_T
8047: WHERE worker_id = g_worker_id;
8048:
8049: EXCEPTION
8050: WHEN OTHERS THEN

Line 8060: INSERT INTO PJI_ac_RMAP_acR_T

8056:
8057: PROCEDURE GET_AC_ROW_IDS IS
8058: BEGIN
8059:
8060: INSERT INTO PJI_ac_RMAP_acR_T
8061: (
8062: worker_id
8063: , pjp1_rowid
8064: , fpr_rowid

Line 8158: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_AC_RMAP_ACR_T_N1) */

8154: , rl.LAST_UPDATED_BY
8155: , rl.LAST_UPDATE_LOGIN
8156: ) =
8157: (
8158: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_AC_RMAP_ACR_T_N1) */
8159: NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
8160: , NVL(rl.INITIAL_FUNDING_AMOUNT, 0) + NVL(tmp.INITIAL_FUNDING_AMOUNT, 0)
8161: , NVL(rl.INITIAL_FUNDING_COUNT, 0) + NVL(tmp.INITIAL_FUNDING_COUNT, 0)
8162: , NVL(rl.ADDITIONAL_FUNDING_AMOUNT, 0) + NVL(tmp.ADDITIONAL_FUNDING_AMOUNT, 0)

Line 8210: PJI_AC_RMAP_ACR_T rwid

8206: , l_last_update_date
8207: , l_last_updated_by
8208: , l_last_update_login
8209: FROM
8210: PJI_AC_RMAP_ACR_T rwid
8211: , PJI_AC_AGGR_PJP1_T tmp
8212: WHERE 1 = 1
8213: AND tmp.worker_id = g_worker_id
8214: AND rwid.worker_id = g_worker_id

Line 8221: FROM PJI_ac_RMAP_acR_T rwid

8217: AND rwid.fpr_rowid IS NOT NULL
8218: )
8219: WHERE rl.rowid IN
8220: ( SELECT fpr_rowid
8221: FROM PJI_ac_RMAP_acR_T rwid
8222: WHERE 1=1
8223: AND rwid.fpr_rowid IS NOT NULL
8224: AND rwid.worker_id = g_worker_id);
8225:

Line 8373: , PJI_ac_RMAP_acR_T rwid

8369: , CUSTOM13
8370: , CUSTOM14
8371: , CUSTOM15
8372: FROM PJI_AC_AGGR_PJP1_T tmp
8373: , PJI_ac_RMAP_acR_T rwid
8374: WHERE 1 = 1
8375: AND tmp.worker_id = g_worker_id
8376: AND rwid.worker_id = g_worker_id
8377: AND tmp.rowid = rwid.pjp1_rowid