APPS.AP_RECURRING_INVOICES_PKG dependencies on PO_VENDOR_SITES

Line 332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;

328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
333: C_retained_amount Number; /*bug 5228301 */
334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
335: C_sched_holds_count NUMBER; --bug 5452979
336:

Line 759: FROM po_vendor_sites pvs

755: debug_info := 'Get terms date and rounding rule';
756: SELECT decode(pvs.terms_date_basis, 'Current', SYSDATE,
757: P_invoice_date)
758: INTO P_terms_date
759: FROM po_vendor_sites pvs
760: WHERE vendor_site_id = P_vendor_site_id;
761:
762:
763: -------------------------------------------

Line 811: po_vendor_sites vs,

807: P_inventory_org_id,
808: P_ship_to_location_id
809: FROM po_vendors v,
810: ap_system_parameters sp,
811: po_vendor_sites vs,
812: financials_system_parameters fsp
813: WHERE v.vendor_id = P_vendor_id
814: AND vs.org_id = sp.org_id
815: AND sp.org_id = fsp.org_id

Line 839: FROM po_vendors pv, po_vendor_sites pvs

835: ---------------------------------------------------------------------
836: debug_info := 'Get Payment Priority';
837: SELECT pvs.payment_priority
838: INTO P_payment_priority
839: FROM po_vendors pv, po_vendor_sites pvs
840: WHERE pv.vendor_id = P_vendor_id
841: AND pvs.vendor_site_id = P_vendor_site_id;
842:
843: ----------------------------------------------------