DBA Data[Home] [Help]

APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on AP_SUPPLIERS

Line 132: l_vendor_id ap_suppliers.vendor_id%TYPE;

128: l_ledger_id gl_ledgers.ledger_id%TYPE;
129: l_ledger_name gl_ledgers.name%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;

Line 133: l_vendor_type ap_suppliers.vendor_type_lookup_code%TYPE;

129: l_ledger_name gl_ledgers.name%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;

Line 231: ap_suppliers aps

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
235: and idpa.document_type = 'STANDARD'