380: /* Bug 2842675 Get the base currency extended precision */
381: SELECT nvl(FND.extended_precision,5)
382: INTO l_base_curr_ext_precision
383: FROM FND_CURRENCIES FND,
384: FINANCIALS_SYSTEM_PARAMETERS FSP,
385: GL_SETS_OF_BOOKS GSB
386: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
387: FND.currency_code = GSB.currency_code;
388:
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1074:
1075: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1076: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1077:
1078: x_rate PO_HEADERS_ALL.rate%TYPE;
1079:
1100: ELSE
1101:
1102: SELECT set_of_books_id
1103: INTO l_sob_id
1104: FROM financials_system_parameters;
1105:
1106: SELECT default_rate_type
1107: INTO l_rate_type
1108: FROM po_system_parameters;