APPS.PJI_PMV_AVL dependencies on PJI_PMV_TIME_DIM_TMP

Line 237: FROM PJI_PMV_TIME_DIM_TMP TIME,

233: ,CASE WHEN (AVAILABLE_RES_COUNT_BKT5_S = 0) THEN 0 ELSE
234: AVAILABLE_HRS_BKT5_S /
235: DECODE(G_LABOUR_UNITS, 'DAYS', IMP.FTE_DAY,
236: 'WEEKS',IMP.FTE_WEEK, 1) END AVL_BKT5
237: FROM PJI_PMV_TIME_DIM_TMP TIME,
238: PJI_PMV_ORGZ_DIM_TMP HORG,
239: PJI_RM_ORGO_F_MV FCT,
240: PJI_PMV_ORG_DIM_TMP HOU,
241: PA_IMPLEMENTATIONS_ALL IMP

Line 272: FROM PJI_PMV_TIME_DIM_TMP TIME,

268: ,0 AVL_BKT2
269: ,0 AVL_BKT3
270: ,0 AVL_BKT4
271: ,0 AVL_BKT5
272: FROM PJI_PMV_TIME_DIM_TMP TIME,
273: PJI_PMV_ORGZ_DIM_TMP HORG,
274: PJI_RM_ORGO_F_MV FCT,
275: PJI_PMV_ORG_DIM_TMP HOU,
276: PA_IMPLEMENTATIONS_ALL IMP

Line 580: DELETE PJI_PMV_TIME_DIM_TMP;

576: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
577: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
578:
579: -- DELETE THE TIME DIMENSION TEMP TABLE FIRST BEFORE INSERTING AGAIN.
580: DELETE PJI_PMV_TIME_DIM_TMP;
581:
582: ----------------------------------------------------
583: -- THIS PART OF THE CODE GET THE NEXT FOUR WEEKS
584: -- TIME_ID FROM THE AS_OF_DATE AND INSERT INTO THE

Line 1041: PJI_PMV_TIME_DIM_TMP TIME,

1037: 'CONSECUTIVE', BCKT_4_CS, 0) CUR_AVL_4
1038: , DECODE (L_AVL_TYPE, 'CUMULATIVE', BCKT_5_CM,
1039: 'CONSECUTIVE', BCKT_5_CS, 0) CUR_AVL_5
1040: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1041: PJI_PMV_TIME_DIM_TMP TIME,
1042: PJI_AV_ORGO_F_MV FCT,
1043: PJI_PMV_ORG_DIM_TMP HOU
1044: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1045: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID

Line 1355: PJI_PMV_TIME_DIM_TMP TIME,

1351: THEN 0 ELSE AVAILABLE_HRS_BKT5_S /
1352: DECODE(G_LABOUR_UNITS, 'DAYS', IMP.FTE_DAY, 'WEEKS',IMP.FTE_WEEK, 1) END) AVL_BKT5
1353:
1354: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1355: PJI_PMV_TIME_DIM_TMP TIME,
1356: PJI_RM_ORGO_F_MV FCT,
1357: PJI_PMV_ORG_DIM_TMP HOU,
1358: PA_IMPLEMENTATIONS_ALL IMP
1359: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID

Line 1382: FROM PJI_PMV_TIME_DIM_TMP

1378: ,0 AVL_BKT2
1379: ,0 AVL_BKT3
1380: ,0 AVL_BKT4
1381: ,0 AVL_BKT5
1382: FROM PJI_PMV_TIME_DIM_TMP
1383: WHERE NAME <> '-1'
1384: ) GROUP BY ORG_ID
1385: ,ORGANIZATION_ID
1386: ,TIME_KEY

Line 1565: PJI_PMV_TIME_DIM_TMP TIME,

1561: , 5, AVAILABLE_RES_COUNT_BKT5_S
1562: , AVAILABLE_RES_COUNT_BKT5_S
1563: ) AVAILABLE_DAYS
1564: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1565: PJI_PMV_TIME_DIM_TMP TIME,
1566: PJI_RM_RES_F FCT,
1567: PJI_PMV_ORG_DIM_TMP HOU,
1568: PA_IMPLEMENTATIONS_ALL IMP
1569: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID

Line 1594: PJI_PMV_TIME_DIM_TMP TIME,

1590: ,0 AVAILABLE
1591: ,0 AVAILABLE_HOURS
1592: ,0 AVAILABLE_DAYS
1593: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1594: PJI_PMV_TIME_DIM_TMP TIME,
1595: PJI_RM_RES_F FCT,
1596: PJI_PMV_ORG_DIM_TMP HOU,
1597: PA_IMPLEMENTATIONS_ALL IMP
1598: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID