DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on GL_CURRENCY_API

Line 54: round(gl_currency_api.get_closest_rate_sql

50:
51: CURSOR converted_unit_price_cur (p_item_id NUMBER, p_source_organization_id NUMBER,
52: p_set_of_books_id NUMBER) IS
53: SELECT msi.list_price_per_unit *
54: round(gl_currency_api.get_closest_rate_sql
55: (p_set_of_books_id,
56: glsob.currency_code,
57: trunc(sysdate),
58: psp.DEFAULT_RATE_TYPE,

Line 71: SELECT round(gl_currency_api.get_closest_rate_sql

67: AND msi.organization_id = hoi.organization_id
68: AND glsob.set_of_books_id = hoi.org_information1;
69:
70: CURSOR conversion_rate_cur IS
71: SELECT round(gl_currency_api.get_closest_rate_sql
72: (p_set_of_books_id,
73: glsob.currency_code,
74: trunc(sysdate),
75: psp.DEFAULT_RATE_TYPE,