DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 6100: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;

6096: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6097:
6098: l_precision fnd_currencies.precision%TYPE;
6099: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
6100: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;
6101:
6102: l_return_status BOOLEAN := TRUE;
6103: l_api_name VARCHAR2(30) := 'Populate_headers_gt'; --bug 6321366
6104: BEGIN

Line 6238: FROM fnd_document_sequences

6234: and p_invoice_header_rec.doc_sequence_id is not null) THEN
6235: BEGIN
6236: SELECT name
6237: INTO l_doc_seq_name
6238: FROM fnd_document_sequences
6239: WHERE doc_sequence_id = p_invoice_header_rec.doc_sequence_id;
6240:
6241: EXCEPTION
6242: WHEN OTHERS THEN

Line 17336: fnd_document_sequences doc,

17332: ai.vendor_id, --ship_third_pty_acct_id
17333: ai.vendor_site_id --ship_third_pty_acct_site_id
17334: FROM ap_invoices_all ai,
17335: fnd_currencies cur,
17336: fnd_document_sequences doc,
17337: ap_invoices_all related_ai,
17338: ap_system_parameters_all asp --Bug14779241
17339: WHERE ai.invoice_currency_code = cur.currency_code
17340: AND ai.doc_sequence_id = doc.doc_sequence_id (+)

Line 18817: , fnd_document_sequences doc

18813: , ai.invoice_type_lookup_code
18814: , ai.quick_credit
18815: , ai.credited_invoice_id
18816: FROM ap_invoices_all ai
18817: , fnd_document_sequences doc
18818: WHERE ai.invoice_id=p_invoice_id
18819: AND ai.doc_sequence_id=doc.doc_sequence_id (+);
18820:
18821: BEGIN