APPS.PA_CAP_INT_PVT dependencies on PA_BUDGET_VERSIONS

Line 180: FROM pa_budget_versions bv

176: SELECT bv.budget_version_id
177: ,bv.budget_entry_method_code
178: ,bv.fin_plan_type_id
179: ,decode(bv.fin_plan_type_id, null,'BUDGET TYPE','PLAN TYPE') threshold_Type
180: FROM pa_budget_versions bv
181: WHERE bv.project_id = p_project_id
182: AND bv.current_flag = 'Y'
183: AND ( (bv.fin_plan_type_id is not NULL
184: and bv.version_type IN ('COST','ALL')

Line 191: from pa_budget_versions bv1

187: OR
188: (bv.fin_plan_type_id is NULL
189: and bv.budget_type_code = p_budget_type_code
190: and NOT EXISTS (select 'Y'
191: from pa_budget_versions bv1
192: where bv1.project_id = bv.project_id
193: and bv1.fin_plan_type_id = p_fin_plan_type_id)
194: )
195: );