APPS.PA_DELETE_ACCUM_RECS dependencies on PA_BUDGET_VERSIONS

Line 208: FROM PA_BUDGET_VERSIONS PABV

204: SELECT PAB.budget_type_code budget_type_code
205: FROM
206: (
207: SELECT pabv.budget_type_code budget_type_code
208: FROM PA_BUDGET_VERSIONS PABV
209: WHERE pabv.Project_id = x_project_id
210: AND pabv.Current_Flag = 'Y'
211: AND pabv.Resource_Accumulated_Flag = 'N'
212: and pabv.budget_type_code IS NOT NULL -- r11.5.7 Budget Model

Line 216: FROM PA_BUDGET_VERSIONS PABV

212: and pabv.budget_type_code IS NOT NULL -- r11.5.7 Budget Model
213: and pabv.Budget_type_code = nvl(x_budget_type_code, pabv.Budget_type_code)
214: UNION ALL
215: SELECT to_char(fin_plan_type_id) budget_type_code
216: FROM PA_BUDGET_VERSIONS PABV
217: WHERE pabv.Project_id = x_project_id
218: AND pabv.Current_Flag = 'Y'
219: AND pabv.Resource_Accumulated_Flag = 'N'
220: and pabv.budget_type_code IS NULL -- Strictly FP model, NO AC/AR budget_type_codes

Line 224: FROM PA_BUDGET_VERSIONS PABV

220: and pabv.budget_type_code IS NULL -- Strictly FP model, NO AC/AR budget_type_codes
221: and x_budget_type_code IS NULL
222: UNION ALL
223: SELECT 'AC' budget_type_code
224: FROM PA_BUDGET_VERSIONS PABV
225: WHERE pabv.Project_id = x_project_id
226: AND pabv.Current_Flag = 'Y'
227: AND pabv.Resource_Accumulated_Flag = 'N'
228: and pabv.budget_type_code IS NULL -- FP model, Approved Cost

Line 233: FROM PA_BUDGET_VERSIONS PABV

229: and nvl(pabv.approved_cost_plan_type_flag, 'N') = 'Y'
230: and 'AC' = nvl(x_budget_type_code, 'AC')
231: UNION ALL
232: SELECT 'AR' budget_type_code
233: FROM PA_BUDGET_VERSIONS PABV
234: WHERE pabv.Project_id = x_project_id
235: AND pabv.Current_Flag = 'Y'
236: AND pabv.Resource_Accumulated_Flag = 'N'
237: and pabv.budget_type_code IS NULL -- FP model, Approved Revenue

Line 242: FROM PA_BUDGET_VERSIONS PABV

238: and nvl(pabv.approved_rev_plan_type_flag, 'N') = 'Y'
239: and 'AR' = nvl(x_budget_type_code, 'AR')
240: UNION ALL
241: SELECT 'FC' budget_type_code
242: FROM PA_BUDGET_VERSIONS PABV
243: WHERE pabv.Project_id = x_project_id
244: AND pabv.Current_Flag = 'Y'
245: AND pabv.Resource_Accumulated_Flag = 'N'
246: and pabv.budget_type_code IS NULL -- FP model, PRIMARY FORECAST Cost

Line 251: FROM PA_BUDGET_VERSIONS PABV

247: and nvl(pabv.primary_cost_forecast_flag, 'N') = 'Y'
248: and 'FC' = nvl(x_budget_type_code, 'FC')
249: UNION ALL
250: SELECT 'FR' budget_type_code
251: FROM PA_BUDGET_VERSIONS PABV
252: WHERE pabv.Project_id = x_project_id
253: AND pabv.Current_Flag = 'Y'
254: AND pabv.Resource_Accumulated_Flag = 'N'
255: and pabv.budget_type_code IS NULL -- FP model, PRIMARY FORECAST Revenue