[Home] [Help]
5677: Reframed the select to use EXISTS instead of DISTINCT
5678: */
5679: SELECT t.budget_type_code
5680: ,t.budget_amount_code
5681: FROM pa_budget_types t
5682: WHERE EXISTS ( SELECT 1
5683: FROM pa_budget_versions v
5684: WHERE v.project_id = x_orig_project_id
5685: AND v.budget_type_code = t.budget_type_code)