APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_PROJECTS_ALL

Line 578: pa_projects_all ppa -- Added for the bug 13617899

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
582: AND pod.project_id =pbco.project_id

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 631: pa_projects_all ppa,

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

Line 676: l_pji_source_flag pa_projects_all.pji_source_flag%TYPE;

672:
673:
674: l_po_header_id po_headers_all.po_header_id%TYPE;
675: l_vendor_id po_headers_all.vendor_id%TYPE;
676: l_pji_source_flag pa_projects_all.pji_source_flag%TYPE;
677: l_multi_mod_val_result_id NUMBER;
678: l_exception_type VARCHAR2(200) := NULL ;
679: l_message_name VARCHAR2(200) := NULL;
680: -- l_count NUMBER :=0; commented for the bug 13617899

Line 788: pa_projects_all pp

784: SELECT NVL(pp.pji_source_flag,'N')
785: INTO l_pji_source_flag
786: FROM po_headers_all poh,
787: po_distributions_all pod,
788: pa_projects_all pp
789: WHERE poh.po_header_id=l_po_header_id
790: AND poh.po_header_id =pod.po_header_id
791: AND pod.project_id =pp.project_id;
792: