APPS.ISC_EDW_BACKLOGS_F_C dependencies on GL_CURRENCY_API

Line 325: GL_CURRENCY_API.get_rate_sql(

321: decode( decode( upper(h.conversion_type_code), 'USER',
322: h.conversion_rate,
323: decode( h.transactional_curr_code, gl.currency_code,
324: 1,
325: GL_CURRENCY_API.get_rate_sql(
326: h.transactional_curr_code,
327: gl.currency_code,
328: h.booked_date,
329: nvl(h.conversion_type_code, edw_param.rate_type)))),

Line 350: GL_CURRENCY_API.get_rate_sql(

346: AND decode( upper(h.conversion_type_code), 'USER',
347: h.conversion_rate,
348: decode( h.transactional_curr_code, gl.currency_code,
349: 1,
350: GL_CURRENCY_API.get_rate_sql(
351: h.transactional_curr_code,
352: gl.currency_code,
353: h.booked_date,
354: nvl(h.conversion_type_code, edw_param.rate_type)))) < 0

Line 409: GL_CURRENCY_API.get_rate_sql (

405: decode( decode( upper(h.conversion_type_code),'USER',
406: 1/ h.conversion_rate,
407: decode( h.transactional_curr_code, gl.currency_code,
408: 1,
409: GL_CURRENCY_API.get_rate_sql (
410: gl.currency_code,
411: h.transactional_curr_code,
412: h.booked_date,
413: nvl(h.conversion_type_code, edw_param.rate_type)))),

Line 434: GL_CURRENCY_API.get_rate_sql (

430: AND decode( upper(h.conversion_type_code),'USER',
431: 1/ h.conversion_rate,
432: decode( h.transactional_curr_code, gl.currency_code,
433: 1,
434: GL_CURRENCY_API.get_rate_sql (
435: gl.currency_code,
436: h.transactional_curr_code,
437: h.booked_date,
438: nvl(h.conversion_type_code, edw_param.rate_type)))) < 0

Line 452: decode(GL_CURRENCY_API.get_rate_sql (

448: '' FROM_UOM_CODE,
449: '' TO_UOM_CODE,
450: '' INVENTORY_ITEM_ID,
451: '' ITEM_NAME,
452: decode(GL_CURRENCY_API.get_rate_sql (
453: gl_cost.currency_code,
454: gl.currency_code,
455: h.booked_date,
456: edw_param.rate_type),

Line 477: AND GL_CURRENCY_API.get_rate_sql (

473: AND h.booked_date IS NOT NULL
474: AND l.ship_from_org_id = hoi.organization_id -- if ship_from_org_id is null, don't include row in the missing rates
475: AND hoi.org_information_context = 'Accounting Information'
476: AND hoi.org_information1 = to_char(gl_cost.set_of_books_id)
477: AND GL_CURRENCY_API.get_rate_sql (
478: gl_cost.currency_code,
479: gl.currency_code,
480: h.booked_date,
481: edw_param.rate_type) < 0;