DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on FND_CURRENCIES

Line 5147: l_precision fnd_currencies.precision%TYPE;

5143: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5144: l_related_inv_date ap_invoices_all.invoice_date%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;

Line 5148: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

5144: l_related_inv_date ap_invoices_all.invoice_date%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

Line 5243: FROM fnd_currencies

5239: IF (l_return_status = TRUE) THEN
5240: BEGIN
5241: SELECT NVL(precision, 0), NVL(minimum_accountable_unit,(1/power(10,precision)))
5242: INTO l_precision, l_minimum_accountable_unit
5243: FROM fnd_currencies
5244: WHERE currency_code = P_Invoice_Header_Rec.invoice_currency_code;
5245:
5246: END;
5247: END IF;

Line 5543: l_precision fnd_currencies.precision%TYPE := 0;

5539: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5542:
5543: l_precision fnd_currencies.precision%TYPE := 0;
5544: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
5545:
5546: l_return_status BOOLEAN := TRUE;
5547: l_api_name VARCHAR2(30) := 'populate_header_import_gt';

Line 5544: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5542:
5543: l_precision fnd_currencies.precision%TYPE := 0;
5544: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
5545:
5546: l_return_status BOOLEAN := TRUE;
5547: l_api_name VARCHAR2(30) := 'populate_header_import_gt';
5548:

Line 5636: FROM fnd_currencies

5632: IF (l_return_status = TRUE) THEN
5633: BEGIN
5634: SELECT NVL(precision, 0), NVL(minimum_accountable_unit,(1/power(10,precision)))
5635: INTO l_precision, l_minimum_accountable_unit
5636: FROM fnd_currencies
5637: WHERE currency_code = P_Invoice_Header_Rec.invoice_currency_code;
5638:
5639: END;
5640: END IF;

Line 13689: fnd_currencies cur,

13685: ai.vendor_site_id, --bill_third_pty_acct_site_id
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 (+)