DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 5149: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;

5145: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5146:
5147: l_precision fnd_currencies.precision%TYPE;
5148: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
5149: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;
5150:
5151: l_return_status BOOLEAN := TRUE;
5152: l_api_name VARCHAR2(30) := 'Populate_headers_gt'; --bug 6321366
5153: BEGIN

Line 5257: FROM fnd_document_sequences

5253: and p_invoice_header_rec.doc_sequence_id is not null) THEN
5254: BEGIN
5255: SELECT name
5256: INTO l_doc_seq_name
5257: FROM fnd_document_sequences
5258: WHERE doc_sequence_id = p_invoice_header_rec.doc_sequence_id;
5259:
5260: EXCEPTION
5261: WHEN OTHERS THEN

Line 13690: fnd_document_sequences doc,

13686: ai.vendor_id, --ship_third_pty_acct_id
13687: ai.vendor_site_id --ship_third_pty_acct_site_id
13688: FROM ap_invoices_all ai,
13689: fnd_currencies cur,
13690: fnd_document_sequences doc,
13691: ap_invoices_all related_ai
13692: WHERE ai.invoice_currency_code = cur.currency_code
13693: AND ai.doc_sequence_id = doc.doc_sequence_id (+)
13694: AND ai.tax_related_invoice_id = related_ai.invoice_id (+)