DBA Data[Home] [Help]

APPS.PA_REV_CA dependencies on PA_BUDGET_VERSIONS

Line 357: FROM pa_budget_versions v

353: BEGIN
354:
355: SELECT v.budget_version_id
356: INTO l_cost_plan_version_id
357: FROM pa_budget_versions v
358: WHERE v.project_id = X2_project_id
359: AND v.current_flag = 'Y'
360: AND v.budget_status_code = 'B'
361: AND v.fin_plan_type_id = l_cost_plan_type_id

Line 374: FROM pa_budget_versions pbv

370:
371: BEGIN
372: SELECT budget_version_id
373: INTO l_cost_budget_version_id
374: FROM pa_budget_versions pbv
375: WHERE project_id = X2_project_id
376: AND budget_type_code = l_cost_budget_type_code
377: AND budget_status_code = 'B'
378: AND current_flag = 'Y';

Line 396: FROM pa_budget_versions v

392: BEGIN
393:
394: SELECT v.budget_version_id
395: INTO l_rev_plan_version_id
396: FROM pa_budget_versions v
397: WHERE v.project_id = X2_project_id
398: AND v.current_flag = 'Y'
399: AND v.budget_status_code = 'B'
400: AND v.fin_plan_type_id = l_rev_plan_type_id

Line 414: FROM pa_budget_versions pbv

410: BEGIN
411:
412: SELECT budget_version_id
413: INTO l_rev_budget_version_id
414: FROM pa_budget_versions pbv
415: WHERE project_id = X2_project_id
416: AND budget_type_code = l_rev_budget_type_code
417: AND budget_status_code = 'B'
418: AND current_flag = 'Y';