DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 149: -- Get city from ap_system_parameters

145: FROM ap_invoices
146: WHERE invoice_id = p_invoice_id;
147:
148: IF NVL(l_payment_location,'$') = '1' THEN -- 1 COMPANY
149: -- Get city from ap_system_parameters
150: select substr(global_attribute4,1,25) city
151: into l_city
152: from ap_system_parameters;
153:

Line 152: from ap_system_parameters;

148: IF NVL(l_payment_location,'$') = '1' THEN -- 1 COMPANY
149: -- Get city from ap_system_parameters
150: select substr(global_attribute4,1,25) city
151: into l_city
152: from ap_system_parameters;
153:
154: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
155: -- Get city from po_vendor_sites
156: select city