DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on PO_VENDOR_SITES

Line 120: -- Get city from po_vendor_sites

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
122: into l_city
123: from po_vendor_sites
124: where vendor_site_id = l_vendor_site_id

Line 123: from po_vendor_sites

119: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
120: -- Get city from po_vendor_sites
121: select city
122: into l_city
123: from po_vendor_sites
124: where vendor_site_id = l_vendor_site_id
125: and nvl(inactive_date,sysdate + 1) > sysdate;
126:
127: END IF;