DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on AP_SUPPLIERS

Line 259: FROM ap_suppliers ap

255: SELECT ap.vendor_id
256: ,ap.vendor_name
257: INTO p_txn_header_rec_type.vendor_id
258: ,p_txn_header_rec_type.vendor_name
259: FROM ap_suppliers ap
260: WHERE (ap.vendor_name = NVL(p_txn_header_rec_type.vendor_name,ap.vendor_name) AND
261: ap.vendor_id = NVL(to_number(p_txn_header_rec_type.vendor_id),ap.vendor_id))
262: AND ap.enabled_flag = 'Y'
263: AND ap.hold_flag = 'N'

Line 5089: FROM ap_suppliers

5085:
5086: BEGIN
5087: SELECT vendor_id
5088: INTO l_supplier_id
5089: FROM ap_suppliers
5090: WHERE vendor_name = p_supplier_name;
5091:
5092:
5093: IF p_supplier_site IS NOT NULL THEN