DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_BUDGET_VERSIONS

Line 572: pa_budget_versions pbv ,

568:
569: CURSOR c_transf_budg_tonewsupp(p_po_header_id IN NUMBER, p_vendor_id IN NUMBER) IS
570: SELECT DISTINCT ppa.segment1 -- Added for the bug 13617899
571: FROM po_distributions_all pod ,
572: pa_budget_versions pbv ,
573: pa_budgetary_control_options pbco,
574: pa_budget_entry_methods pbe ,
575: pa_budget_lines pbl ,
576: pa_resource_assignments pra ,

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 633: pa_budget_versions pbv

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
637: AND ((pbv.budget_status_code ='B'