DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_BUDGET_TYPES

Line 625: -- modified below cursor for the bug 13617899 and added pa_projects_all,pa_budget_types and pa_budget_versions tables

621: AND ppd.cmt_qty <> 0; -- Modified for the bug 13566375
622:
623:
624: --Cursor to check if there are any budgetary control defined for the Old Supplier.
625: -- modified below cursor for the bug 13617899 and added pa_projects_all,pa_budget_types and pa_budget_versions tables
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,

Line 632: pa_budget_types pbt,

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
635: AND ppa.project_id=pbc.project_id
636: AND pbv.project_id=pbc.project_id