APPS.AP_AUTO_DM_CREATION_PKG dependencies on PO_VENDORS

Line 227: l_type_1099 po_vendors.type_1099%TYPE;

223:
224: l_payment_priority po_vendor_sites.payment_priority%TYPE;
225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;

Line 947: value in the vendor site first and if null else get value from po_vendors

943: End Get_Receipt_Info;
944:
945: /*-------------------------------------------------------------------------
946: GET_VENDOR_INFO : Get vendor and vendor site related information. Look for
947: value in the vendor site first and if null else get value from po_vendors
948: --------------------------------------------------------------------------*/
949: Procedure Get_vendor_info (
950: p_vendor_id IN NUMBER,
951: p_vendor_site_id IN NUMBER,

Line 1016: FROM po_vendors pv,

1012: p_payment_currency,
1013: p_auto_tax_calc_flag,
1014: p_party_id,
1015: p_party_site_id
1016: FROM po_vendors pv,
1017: ap_supplier_sites pvs
1018: WHERE pvs.vendor_site_id = p_vendor_site_id --l_default_pay_site_id modified for bug#9267199
1019: and pv.vendor_id = pvs.vendor_id;
1020: