APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_VENDOR_SITES_ALL

Line 84: FROM Po_Vendor_Sites_All A

80: WHERE Vendor_Name = p_sugg_vendor_name;
81:
82: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
83: SELECT Vendor_Site_Id
84: FROM Po_Vendor_Sites_All A
85: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
86: AND A.Vendor_Id = v_vendor_id
87: AND (A.Org_Id = v_org_id
88: OR

Line 1805: FROM Po_Vendor_Sites_All A

1801: WHERE vendor_name = p_sugg_vendor_name;
1802:
1803: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
1804: SELECT Vendor_Site_Id
1805: FROM Po_Vendor_Sites_All A
1806: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
1807: AND A.Vendor_Id = v_vendor_id
1808: AND (A.Org_Id = v_org_id
1809: OR

Line 2550: FROM Po_vendor_Sites_All A

2546: FROM po_vendors
2547: WHERE vendor_name = p_sugg_vendor_name;
2548:
2549: Cursor site_cur(p_sugg_vendor_loc IN VARCHAR2) IS SELECT vendor_Site_Id
2550: FROM Po_vendor_Sites_All A
2551: WHERE A.vendor_Site_Code = p_sugg_vendor_loc
2552: AND A.vendor_Id = v_vendor_id
2553: AND nvl(A.Org_Id,0) = nvl(v_org_id,0);
2554: