DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on AP_SUPPLIERS

Line 254: FROM ap_suppliers ap

250: SELECT ap.vendor_id
251: ,ap.vendor_name
252: INTO p_txn_header_rec_type.vendor_id
253: ,p_txn_header_rec_type.vendor_name
254: FROM ap_suppliers ap
255: WHERE (ap.vendor_name = NVL(p_txn_header_rec_type.vendor_name,ap.vendor_name) AND
256: ap.vendor_id = NVL(to_number(p_txn_header_rec_type.vendor_id),ap.vendor_id))
257: AND ap.enabled_flag = 'Y'
258: AND ap.hold_flag = 'N'

Line 4802: FROM ap_suppliers

4798:
4799: BEGIN
4800: SELECT vendor_id
4801: INTO l_supplier_id
4802: FROM ap_suppliers
4803: WHERE vendor_name = p_supplier_name;
4804:
4805:
4806: IF p_supplier_site IS NOT NULL THEN