DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_BUDGET_VERSIONS

Line 172: FROM pa_budget_versions v

168: BEGIN
169:
170: SELECT v.budget_version_id
171: INTO l_cost_plan_version_id
172: FROM pa_budget_versions v
173: WHERE v.project_id = X2_project_id
174: AND v.current_flag = 'Y'
175: AND v.budget_status_code = 'B'
176: AND v.fin_plan_type_id = l_cost_plan_type_id

Line 189: FROM pa_budget_versions pbv

185:
186: BEGIN
187: SELECT budget_version_id
188: INTO l_cost_budget_version_id
189: FROM pa_budget_versions pbv
190: WHERE project_id = X2_project_id
191: AND budget_type_code = l_cost_budget_type_code
192: AND budget_status_code = 'B'
193: AND current_flag = 'Y';

Line 209: FROM pa_budget_versions v

205: BEGIN
206:
207: SELECT v.budget_version_id
208: INTO l_rev_plan_version_id
209: FROM pa_budget_versions v
210: WHERE v.project_id = X2_project_id
211: AND v.current_flag = 'Y'
212: AND v.budget_status_code = 'B'
213: AND v.fin_plan_type_id = l_rev_plan_type_id

Line 227: FROM pa_budget_versions pbv

223: BEGIN
224:
225: SELECT budget_version_id
226: INTO l_rev_budget_version_id
227: FROM pa_budget_versions pbv
228: WHERE project_id = X2_project_id
229: AND budget_type_code = l_rev_budget_type_code
230: AND budget_status_code = 'B'
231: AND current_flag = 'Y';