DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on FND_CURRENCIES

Line 100: select 'x' from fnd_currencies

96: select 'x' from oke_system_items_v
97: where id1=b_item_id and id2=b_inv_org_id;
98:
99: Cursor c_check_currency(b_currency_code Varchar2) is
100: select 'x' from fnd_currencies
101: where currency_code=b_currency_code
102: and enabled_flag='Y'
103: and currency_flag='Y'
104: and sysdate >= nvl(start_date_active,sysdate)

Line 308: Select 'x' from fnd_currencies b

304: x_return_status OUT NOCOPY VARCHAR2
305: ) IS
306: l_inv number;
307: Cursor c_check_currency IS
308: Select 'x' from fnd_currencies b
309: where enabled_flag = 'Y'
310: and currency_flag = 'Y'
311: and b.currency_code = p_currency_code
312: and sysdate >= nvl (b.start_date_active, sysdate)