DBA Data[Home] [Help]

APPS.PA_BUDGET_UTILS2 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 311: pa_resource_assignments r

307: where exists
308: (select 'x' /* Old budgets model */
309: from pa_budget_versions v,
310: pa_budget_entry_methods m,
311: pa_resource_assignments r
312: where r.task_id = x_task_id
313: and ( (m.entry_level_code = 'L')
314: or
315: (m.entry_level_code = 'M'

Line 324: pa_resource_assignments r,

320: and v.budget_type_code is not null
321: union all
322: select 'x' /* Org Forcast Versions */
323: from pa_budget_versions v,
324: pa_resource_assignments r,
325: pa_fin_plan_types_b pft
326: where r.task_id = x_task_id
327: and v.budget_type_code is null
328: and v.budget_version_id = r.budget_version_id

Line 348: pa_resource_assignments r

344: where exists
345: (select 'x' /* Old budgets model */
346: from pa_budget_versions v,
347: pa_budget_entry_methods m,
348: pa_resource_assignments r
349: where r.task_id = x_task_id
350: and ( (m.entry_level_code = 'L')
351: or
352: (m.entry_level_code = 'M'

Line 361: pa_resource_assignments r,

357: and v.budget_type_code is not null
358: union all
359: select 'x' /* Org Forcast Versions */
360: from pa_budget_versions v,
361: pa_resource_assignments r,
362: pa_fin_plan_types_b pft
363: where r.task_id = x_task_id
364: and v.budget_type_code is null
365: and v.budget_version_id = r.budget_version_id