573: pa_budgetary_control_options pbco,
574: pa_budget_entry_methods pbe ,
575: pa_budget_lines pbl ,
576: pa_resource_assignments pra ,
577: pa_resource_list_members prlm,
578: pa_projects_all ppa -- Added for the bug 13617899
579: WHERE pod.po_header_id =p_po_header_id
580: AND ppa.project_id = pod.project_id -- Added for the bug 13617899
581: AND pod.project_id = pbv.project_id
626:
627: CURSOR c_check_supp_budgctrl(p_po_header_id IN NUMBER, p_vendor_id IN NUMBER) IS
628: SELECT DISTINCT ppa.segment1, pbt.budget_type -- Added for the bug 13617899
629: FROM pa_budgetary_controls pbc,
630: pa_resource_list_members prlm,
631: pa_projects_all ppa,
632: pa_budget_types pbt,
633: pa_budget_versions pbv
634: WHERE prlm.vendor_id = p_vendor_id