APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on GL_PERIODS

Line 1067: GL_PERIODS GLP

1063: SUM(FI.ITEM_QUANTITY),
1064: MIN(FI.FORECAST_ITEM_ID)
1065: FROM PA_FORECAST_ITEMS FI,
1066: PA_FORECAST_ITEM_DETAILS FID,
1067: GL_PERIODS GLP
1068: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1069: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1070: AND FID.NET_ZERO_FLAG = 'N'
1071: AND FI.ERROR_FLAG = 'N'

Line 1230: GL_PERIODS GLP,

1226: RLM.RESOURCE_LIST_ID,
1227: RLM.ALIAS
1228: FROM PA_FORECAST_ITEMS FI,
1229: PA_FORECAST_ITEM_DETAILS FID,
1230: GL_PERIODS GLP,
1231: PA_RES_LIST_MAP_TMP4 TMP4,
1232: PA_RESOURCE_ASSIGNMENTS RA,
1233: PA_RESOURCE_LIST_MEMBERS RLM
1234: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID

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

2774:
2775: END IF;
2776:
2777: -- 2. Call PA_PLAN_REVENUE.GET_PLANNING_RATES API based on periodic data
2778: -- in PA/GL periods. Need to also pass in billability flag. (Project
2779: -- assignments with different bill rate override currency are mapped
2780: -- to different budget lines.)
2781: FOR k in 1..l_rt_start_date_tab.COUNT LOOP
2782: