833: select aerh.default_currency_code,
834: aerh.total,
835: sp.default_exchange_rate_type
836: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
837: ap_system_parameters_all sp
838: where aerh.report_header_id = p_report_header_id
839: and sp.org_id = aerh.org_id;
840:
841: report_rec report_cur%ROWTYPE;
1284: IF list_cur%FOUND THEN
1285:
1286: BEGIN
1287: SELECT base_currency_code INTO l_base_currency_code
1288: FROM ap_system_parameters_all
1289: WHERE org_id = list_rec.org_id;
1290: l_ex_rate := AP_UTILITIES_PKG.get_exchange_rate(
1291: list_rec.default_currency_code,
1292: l_base_currency_code,