APPS.AP_ETAX_SERVICES_PKG dependencies on FND_CURRENCIES

Line 6098: l_precision fnd_currencies.precision%TYPE;

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

Line 6099: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

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

Line 6221: FROM fnd_currencies

6217: IF (l_return_status = TRUE) THEN
6218: BEGIN
6219: SELECT NVL(precision, 0), NVL(minimum_accountable_unit,(1/power(10,precision)))
6220: INTO l_precision, l_minimum_accountable_unit
6221: FROM fnd_currencies
6222: WHERE currency_code = P_Invoice_Header_Rec.invoice_currency_code;
6223:
6224: END;
6225: END IF;

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

6523: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6526:
6527: l_precision fnd_currencies.precision%TYPE := 0;
6528: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
6529:
6530: l_return_status BOOLEAN := TRUE;
6531: l_api_name VARCHAR2(30) := 'populate_header_import_gt';

Line 6528: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6526:
6527: l_precision fnd_currencies.precision%TYPE := 0;
6528: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
6529:
6530: l_return_status BOOLEAN := TRUE;
6531: l_api_name VARCHAR2(30) := 'populate_header_import_gt';
6532:

Line 6645: FROM fnd_currencies

6641: IF (l_return_status = TRUE) THEN
6642: BEGIN
6643: SELECT NVL(precision, 0), NVL(minimum_accountable_unit,(1/power(10,precision)))
6644: INTO l_precision, l_minimum_accountable_unit
6645: FROM fnd_currencies
6646: WHERE currency_code = P_Invoice_Header_Rec.invoice_currency_code;
6647:
6648: END;
6649: END IF;

Line 17335: fnd_currencies cur,

17331: ai.vendor_site_id, --bill_third_pty_acct_site_id
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