APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_VENDORS

Line 79: FROM Po_Vendors

75: * and implemented the same using caching logic.
76: */
77: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
78: SELECT Vendor_Id
79: FROM Po_Vendors
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

Line 988: FROM Po_Vendors

984: WHERE Tax_Id = taxid;
985:
986: CURSOR Fetch_Vendor_Id IS
987: SELECT Vendor_Id
988: FROM Po_Vendors
989: WHERE Vendor_Name = v_sugg_vendor_name;
990:
991: -- Get the header currency code
992:

Line 1800: FROM po_vendors

1796: WHERE Requisition_Header_Id = v_header_id;
1797:
1798: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
1799: SELECT vendor_id
1800: FROM po_vendors
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

Line 2546: FROM po_vendors

2542: FROM Po_Requisition_Headers_All
2543: WHERE Requisition_Header_Id = v_header_id;
2544:
2545: Cursor Vend_cur(p_sugg_vendor_name IN VARCHAR2) IS SELECT vendor_id
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