DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_BUDGET_VERSIONS

Line 1225: FROM pa_budget_versions v

1221: BEGIN
1222:
1223: SELECT v.budget_version_id
1224: INTO l_rev_plan_version_id
1225: FROM pa_budget_versions v
1226: WHERE v.project_id = X2_project_id
1227: AND v.current_flag = 'Y'
1228: AND v.budget_status_code = 'B'
1229: AND v.fin_plan_type_id = l_rev_plan_type_id

Line 1241: FROM pa_budget_versions pbv

1237: BEGIN
1238:
1239: SELECT budget_version_id
1240: INTO l_rev_budget_version_id
1241: FROM pa_budget_versions pbv
1242: WHERE project_id = X2_project_id
1243: AND budget_type_code = l_rev_budget_type_code
1244: AND budget_status_code = 'B'
1245: AND current_flag = 'Y';