APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_CURRENCY

Line 6292: SELECT FND.currency_code, nvl(FND.extended_precision,5)

6288: --Bug 1991546
6289: --Obtain extended precision of PO/Release functional currency which is
6290: --used for rounding while checking for tolerance
6291: BEGIN
6292: SELECT FND.currency_code, nvl(FND.extended_precision,5)
6293: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
6294: FROM fnd_currencies FND, financials_system_parameters FSP,
6295: gl_sets_of_books SOB
6296: WHERE FSP.set_of_books_id = SOB.set_of_books_id

Line 6297: AND SOB.currency_code = FND.currency_code;

6293: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
6294: FROM fnd_currencies FND, financials_system_parameters FSP,
6295: gl_sets_of_books SOB
6296: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6297: AND SOB.currency_code = FND.currency_code;
6298: EXCEPTION
6299: WHEN OTHERS THEN
6300: RAISE;
6301: END;

Line 10566: fnd_currency.get_info (l_currency_code,

10562: into l_currency_code
10563: FROM PO_HEADERS_GT POH
10564: WHERE POH.po_header_id = p_document_id;
10565:
10566: fnd_currency.get_info (l_currency_code,
10567: l_precision,
10568: l_ext_precision,
10569: l_min_acct_unit);
10570: /* End bug 14196636 - Query to fetch precision for currency */

Line 26601: l_limit_amount := TO_CHAR(l_doc_threshold_amount, FND_CURRENCY.GET_FORMAT_MASK(l_user_currency ,60)) || ' ' || l_user_currency;

26597: IF ( (l_changed_amt > l_doc_threshold_amount AND l_doc_threshold_amount > 0 )AND
26598: (p_contract_rec.contract_id is NULL)
26599: )THEN
26600: l_user_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', p_user_id);
26601: l_limit_amount := TO_CHAR(l_doc_threshold_amount, FND_CURRENCY.GET_FORMAT_MASK(l_user_currency ,60)) || ' ' || l_user_currency;
26602: INSERT INTO po_online_report_text_gt
26603: (online_report_id
26604: ,last_updated_by
26605: ,last_update_date