APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_AC_RMAP_ACR_T

Line 7898: DELETE FROM PJI_ac_RMAP_acR_T

7894:
7895: PROCEDURE CLEANUP_AC_RMAP_FPR IS
7896: BEGIN
7897:
7898: DELETE FROM PJI_ac_RMAP_acR_T
7899: WHERE worker_id = g_worker_id;
7900:
7901: EXCEPTION
7902: WHEN OTHERS THEN

Line 7912: INSERT INTO PJI_ac_RMAP_acR_T

7908:
7909: PROCEDURE GET_AC_ROW_IDS IS
7910: BEGIN
7911:
7912: INSERT INTO PJI_ac_RMAP_acR_T
7913: (
7914: worker_id
7915: , pjp1_rowid
7916: , fpr_rowid

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

8006: , rl.LAST_UPDATED_BY
8007: , rl.LAST_UPDATE_LOGIN
8008: ) =
8009: (
8010: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_AC_RMAP_ACR_T_N1) */
8011: NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
8012: , NVL(rl.INITIAL_FUNDING_AMOUNT, 0) + NVL(tmp.INITIAL_FUNDING_AMOUNT, 0)
8013: , NVL(rl.INITIAL_FUNDING_COUNT, 0) + NVL(tmp.INITIAL_FUNDING_COUNT, 0)
8014: , NVL(rl.ADDITIONAL_FUNDING_AMOUNT, 0) + NVL(tmp.ADDITIONAL_FUNDING_AMOUNT, 0)

Line 8062: PJI_AC_RMAP_ACR_T rwid

8058: , l_last_update_date
8059: , l_last_updated_by
8060: , l_last_update_login
8061: FROM
8062: PJI_AC_RMAP_ACR_T rwid
8063: , PJI_AC_AGGR_PJP1_T tmp
8064: WHERE 1 = 1
8065: AND tmp.worker_id = g_worker_id
8066: AND rwid.worker_id = g_worker_id

Line 8073: FROM PJI_ac_RMAP_acR_T rwid

8069: AND rwid.fpr_rowid IS NOT NULL
8070: )
8071: WHERE rl.rowid IN
8072: ( SELECT fpr_rowid
8073: FROM PJI_ac_RMAP_acR_T rwid
8074: WHERE 1=1
8075: AND rwid.fpr_rowid IS NOT NULL
8076: AND rwid.worker_id = g_worker_id);
8077:

Line 8225: , PJI_ac_RMAP_acR_T rwid

8221: , CUSTOM13
8222: , CUSTOM14
8223: , CUSTOM15
8224: FROM PJI_AC_AGGR_PJP1_T tmp
8225: , PJI_ac_RMAP_acR_T rwid
8226: WHERE 1 = 1
8227: AND tmp.worker_id = g_worker_id
8228: AND rwid.worker_id = g_worker_id
8229: AND tmp.rowid = rwid.pjp1_rowid