APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_VENDORS

Line 85: FROM Po_Vendors

81: * and implemented the same using caching logic.
82: */
83: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
84: SELECT Vendor_Id
85: FROM Po_Vendors
86: WHERE Vendor_Name = p_sugg_vendor_name;
87:
88: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
89: SELECT Vendor_Site_Id

Line 1075: FROM Po_Vendors

1071: WHERE Tax_Id = taxid;
1072:
1073: CURSOR Fetch_Vendor_Id IS
1074: SELECT Vendor_Id
1075: FROM Po_Vendors
1076: WHERE Vendor_Name = v_sugg_vendor_name;
1077:
1078: -- Get the header currency code
1079:

Line 1931: FROM po_vendors

1927: WHERE Requisition_Header_Id = v_header_id;
1928:
1929: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
1930: SELECT vendor_id
1931: FROM po_vendors
1932: WHERE vendor_name = p_sugg_vendor_name;
1933:
1934: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
1935: SELECT Vendor_Site_Id

Line 2769: FROM po_vendors

2765: FROM Po_Requisition_Headers_All
2766: WHERE Requisition_Header_Id = v_header_id;
2767:
2768: Cursor Vend_cur(p_sugg_vendor_name IN VARCHAR2) IS SELECT vendor_id
2769: FROM po_vendors
2770: WHERE vendor_name = p_sugg_vendor_name;
2771:
2772: Cursor site_cur(p_sugg_vendor_loc IN VARCHAR2) IS SELECT vendor_Site_Id
2773: FROM Po_vendor_Sites_All A