DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 114: -- Get city from ap_system_parameters

110: FROM ap_invoices
111: WHERE invoice_id = p_invoice_id;
112:
113: IF NVL(l_payment_location,'$') = '1' THEN -- 1 COMPANY
114: -- Get city from ap_system_parameters
115: select substr(global_attribute4,1,25) city
116: into l_city
117: from ap_system_parameters;
118:

Line 117: from ap_system_parameters;

113: IF NVL(l_payment_location,'$') = '1' THEN -- 1 COMPANY
114: -- Get city from ap_system_parameters
115: select substr(global_attribute4,1,25) city
116: into l_city
117: from ap_system_parameters;
118:
119: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
120: -- Get city from po_vendor_sites
121: select city