APPS.AP_RECURRING_INVOICES_PKG dependencies on PO_VENDOR_SITES

Line 338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;

334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
339: C_retained_amount Number; /*bug 5228301 */
340: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
341: C_sched_holds_count NUMBER; --bug 5452979
342:

Line 783: FROM po_vendor_sites pvs

779: debug_info := 'Get terms date and rounding rule';
780: SELECT decode(pvs.terms_date_basis, 'Current', SYSDATE,
781: P_invoice_date)
782: INTO P_terms_date
783: FROM po_vendor_sites pvs
784: WHERE vendor_site_id = P_vendor_site_id;
785:
786:
787: -------------------------------------------

Line 835: po_vendor_sites vs,

831: P_inventory_org_id,
832: P_ship_to_location_id
833: FROM po_vendors v,
834: ap_system_parameters sp,
835: po_vendor_sites vs,
836: financials_system_parameters fsp
837: WHERE v.vendor_id = P_vendor_id
838: AND vs.org_id = sp.org_id
839: AND sp.org_id = fsp.org_id

Line 863: FROM po_vendors pv, po_vendor_sites pvs

859: ---------------------------------------------------------------------
860: debug_info := 'Get Payment Priority';
861: SELECT pvs.payment_priority
862: INTO P_payment_priority
863: FROM po_vendors pv, po_vendor_sites pvs
864: WHERE pv.vendor_id = P_vendor_id
865: AND pvs.vendor_site_id = P_vendor_site_id;
866:
867: ----------------------------------------------------