APPS.IEX_UTILITIES dependencies on GL_SETS_OF_BOOKS

Line 1574: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob

1570: -- because there is more than 1 record for the same site_use_id, so we pick the functional currency one
1571: cursor c_billto (p_customer_site_use_id number) is
1572: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
1573: where site_use_id = p_customer_site_use_id and currency_code = (
1574: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob
1575: WHERE sob.set_of_books_id = sp.set_of_books_id);
1576:
1577: -- only open status
1578: cursor c_amount_billto (p_site_use_id number) is

Line 1591: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob

1587: cursor c_account (p_cust_account_id number) is
1588: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
1589: from hz_cust_profile_amts
1590: where cust_account_id = p_cust_account_id and currency_code = (
1591: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob
1592: WHERE sob.set_of_books_id = sp.set_of_books_id);
1593:
1594: -- only open status
1595: cursor c_amount_account (p_cust_account_id number) is