DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on PO_VENDORS

Line 258: FROM po_vendors

254: IF p_ei_rec.transaction_source = 'CSE_PO_RECEIPT' THEN
255: BEGIN
256: SELECT segment1
257: INTO x_nl_pa_interface_rec.vendor_number
258: FROM po_vendors
259: WHERE vendor_id = p_ei_rec.system_reference1;
260: EXCEPTION
261: WHEN no_data_found THEN
262: x_nl_pa_interface_rec.system_linkage := 'INV';

Line 533: FROM po_vendors

529: IF ei_rec.transaction_source = 'CSE_PO_RECEIPT' THEN
530: BEGIN
531: SELECT segment1
532: INTO l_nl_pa_interface_tbl(i).vendor_number
533: FROM po_vendors
534: WHERE vendor_id = ei_rec.system_reference1;
535: EXCEPTION
536: WHEN no_data_found THEN
537: l_nl_pa_interface_tbl(i).system_linkage := 'INV';