DBA Data[Home] [Help]

APPS.PO_CREATE_REQUISITION_SV dependencies on GL_CURRENCY_API

Line 54: round(gl_currency_api.get_closest_rate_sql

50: -- Get Converted Unit Price for Purchase Requsitions
51: CURSOR converted_unit_price_int_csr (p_item_id NUMBER, p_source_organization_id NUMBER,
52: s_currency_code VARCHAR2, d_currency_code varchar2 ) IS
53: SELECT cic.item_cost *
54: round(gl_currency_api.get_closest_rate_sql
55: (s_currency_code,
56: d_currency_code,
57: trunc(sysdate),
58: psp.DEFAULT_RATE_TYPE,

Line 72: round(gl_currency_api.get_closest_rate_sql

68: -- Get Converted Unit Price for Purchase Requsitions
69: CURSOR converted_unit_price_pur_cur (p_item_id NUMBER, p_source_organization_id NUMBER,
70: p_set_of_books_id NUMBER) IS
71: SELECT msi.list_price_per_unit *
72: round(gl_currency_api.get_closest_rate_sql
73: (p_set_of_books_id,
74: glsob.currency_code,
75: trunc(sysdate),
76: psp.DEFAULT_RATE_TYPE,