DBA Data[Home] [Help]

APPS.PJI_PMV_AVL dependencies on PA_IMPLEMENTATIONS_ALL

Line 241: PA_IMPLEMENTATIONS_ALL IMP

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
244: AND HOU.ID = IMP.ORG_ID
245: AND FCT.TIME_ID = TIME.ID

Line 276: PA_IMPLEMENTATIONS_ALL IMP

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
279: AND HOU.ID = IMP.ORG_ID
280: AND FCT.TIME_ID = TIME.ID

Line 1358: PA_IMPLEMENTATIONS_ALL IMP

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
1361: AND HOU.ID = IMP.ORG_ID
1362: AND FCT.TIME_ID = TIME.ID

Line 1568: PA_IMPLEMENTATIONS_ALL IMP

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
1570: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1571: AND FCT.TIME_ID = TIME.ID
1572: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 1597: PA_IMPLEMENTATIONS_ALL IMP

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
1599: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1600: AND FCT.TIME_ID = TIME.ID
1601: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE