APPS.PJI_PMV_AVL dependencies on PJI_RM_ORGO_F_MV

Line 239: PJI_RM_ORGO_F_MV FCT,

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
242: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
243: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID

Line 274: PJI_RM_ORGO_F_MV FCT,

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
277: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
278: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID

Line 1017: PJI_RM_ORGO_F_MV FCT,

1013: , 0 CUR_AVL_3
1014: , 0 CUR_AVL_4
1015: , 0 CUR_AVL_5
1016: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1017: PJI_RM_ORGO_F_MV FCT,
1018: PJI_PMV_ORG_DIM_TMP HOU
1019: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1020: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1021: AND FCT.PERIOD_TYPE_ID = l_DAY_PERIOD_TYPE

Line 1356: PJI_RM_ORGO_F_MV FCT,

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
1360: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID