DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_BUDGET_VERSIONS

Line 1223: FROM pa_budget_versions v

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

Line 1239: FROM pa_budget_versions pbv

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