DBA Data[Home] [Help]

APPS.RCV_HEADERS_INTERFACE_SV dependencies on PO_VENDOR_SITES_ALL

Line 1319: FROM po_vendor_sites_all --Bug 5219141 Replace po_vendor_sites by po_vendor_sites_all

1315: p_inv_rec IN OUT NOCOPY rcv_shipment_header_sv.invrectype
1316: ) IS
1317: CURSOR c IS
1318: SELECT invoice_amount_limit
1319: FROM po_vendor_sites_all --Bug 5219141 Replace po_vendor_sites by po_vendor_sites_all
1320: WHERE po_vendor_sites_all.vendor_site_id = p_inv_rec.vendor_site_id
1321: AND po_vendor_sites_all.vendor_id = p_inv_rec.vendor_id;
1322:
1323: x_inv_rec c%ROWTYPE;

Line 1320: WHERE po_vendor_sites_all.vendor_site_id = p_inv_rec.vendor_site_id

1316: ) IS
1317: CURSOR c IS
1318: SELECT invoice_amount_limit
1319: FROM po_vendor_sites_all --Bug 5219141 Replace po_vendor_sites by po_vendor_sites_all
1320: WHERE po_vendor_sites_all.vendor_site_id = p_inv_rec.vendor_site_id
1321: AND po_vendor_sites_all.vendor_id = p_inv_rec.vendor_id;
1322:
1323: x_inv_rec c%ROWTYPE;
1324: BEGIN

Line 1321: AND po_vendor_sites_all.vendor_id = p_inv_rec.vendor_id;

1317: CURSOR c IS
1318: SELECT invoice_amount_limit
1319: FROM po_vendor_sites_all --Bug 5219141 Replace po_vendor_sites by po_vendor_sites_all
1320: WHERE po_vendor_sites_all.vendor_site_id = p_inv_rec.vendor_site_id
1321: AND po_vendor_sites_all.vendor_id = p_inv_rec.vendor_id;
1322:
1323: x_inv_rec c%ROWTYPE;
1324: BEGIN
1325: /*Commenting out the following check because if this is called