DBA Data[Home] [Help]

APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on AP_INVOICES_ALL

Line 134: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;

130: l_coa gl_ledgers.chart_of_accounts_id%TYPE;
131: l_delimiter VARCHAR2(1);
132: l_vendor_id ap_suppliers.vendor_id%TYPE;
133: l_vendor_type ap_suppliers.vendor_type_lookup_code%TYPE;
134: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
135: l_offset_flag varchar2(1);
136: l_acc_dist_tbl Fnd_Flex_Ext.segmentarray;
137: l_fv_low_tbl Fnd_Flex_Ext.segmentarray;
138: l_fv_high_tbl Fnd_Flex_Ext.segmentarray;

Line 230: ap_invoices_all aia,

226: select aia.vendor_id, aia.vendor_site_id, aps.vendor_type_lookup_code
227: into l_vendor_id, l_vendor_site_id, l_vendor_type
228: from iby_payments_all ipa,
229: iby_docs_payable_all idpa,
230: ap_invoices_all aia,
231: ap_suppliers aps
232: where ipa.payment_id = p_payment_id
233: and ipa.payment_id = idpa.payment_id
234: and idpa.calling_app_id = 200