DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on PO_VENDOR_SITES_ALL

Line 35: CURSOR vendorinfo(p_base_language po_vendor_sites_all.language%TYPE,

31: l_sum_discount NUMBER; -- 3641604
32: l_paid_amount NUMBER; -- 2901541
33: --The cursor vendorinfo holds all the information about the vendor and vendor site
34:
35: CURSOR vendorinfo(p_base_language po_vendor_sites_all.language%TYPE,
36: p_session_language po_vendor_sites_all.language%TYPE ) is
37: SELECT
38: pv.vendor_id,
39: pv.vendor_name supplier_name,

Line 36: p_session_language po_vendor_sites_all.language%TYPE ) is

32: l_paid_amount NUMBER; -- 2901541
33: --The cursor vendorinfo holds all the information about the vendor and vendor site
34:
35: CURSOR vendorinfo(p_base_language po_vendor_sites_all.language%TYPE,
36: p_session_language po_vendor_sites_all.language%TYPE ) is
37: SELECT
38: pv.vendor_id,
39: pv.vendor_name supplier_name,
40: pv.segment1 supplier_number,