DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on PO_VENDORS

Line 252: FROM po_vendors

248: IF p_ei_rec.transaction_source = 'CSE_PO_RECEIPT' THEN
249: BEGIN
250: SELECT segment1
251: INTO x_nl_pa_interface_rec.vendor_number
252: FROM po_vendors
253: WHERE vendor_id = p_ei_rec.system_reference1;
254: EXCEPTION
255: WHEN no_data_found THEN
256: x_nl_pa_interface_rec.system_linkage := 'INV';

Line 521: FROM po_vendors

517: IF ei_rec.transaction_source = 'CSE_PO_RECEIPT' THEN
518: BEGIN
519: SELECT segment1
520: INTO l_nl_pa_interface_tbl(i).vendor_number
521: FROM po_vendors
522: WHERE vendor_id = ei_rec.system_reference1;
523: EXCEPTION
524: WHEN no_data_found THEN
525: l_nl_pa_interface_tbl(i).system_linkage := 'INV';