DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on GL_PERIODS

Line 1055: GL_PERIODS GLP

1051: SUM(FI.ITEM_QUANTITY),
1052: MIN(FI.FORECAST_ITEM_ID)
1053: FROM PA_FORECAST_ITEMS FI,
1054: PA_FORECAST_ITEM_DETAILS FID,
1055: GL_PERIODS GLP
1056: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1057: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1058: AND FID.NET_ZERO_FLAG = 'N'
1059: AND FI.ERROR_FLAG = 'N'

Line 1218: GL_PERIODS GLP,

1214: RLM.RESOURCE_LIST_ID,
1215: RLM.ALIAS
1216: FROM PA_FORECAST_ITEMS FI,
1217: PA_FORECAST_ITEM_DETAILS FID,
1218: GL_PERIODS GLP,
1219: PA_RES_LIST_MAP_TMP4 TMP4,
1220: PA_RESOURCE_ASSIGNMENTS RA,
1221: PA_RESOURCE_LIST_MEMBERS RLM
1222: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID

Line 2766: -- in PA/GL periods. Need to also pass in billability flag. (Project

2762:
2763: END IF;
2764:
2765: -- 2. Call PA_PLAN_REVENUE.GET_PLANNING_RATES API based on periodic data
2766: -- in PA/GL periods. Need to also pass in billability flag. (Project
2767: -- assignments with different bill rate override currency are mapped
2768: -- to different budget lines.)
2769: FOR k in 1..l_rt_start_date_tab.COUNT LOOP
2770: