APPS.AR_RECEIPT_VAL_PVT dependencies on GL_SETS_OF_BOOKS

Line 2878: FROM AR_SYSTEM_PARAMETERS sys,gl_sets_of_books sob

2874: sob.currency_code
2875: INTO l_max_wrt_off_amount,
2876: l_min_wrt_off_amount,
2877: l_functional_currency
2878: FROM AR_SYSTEM_PARAMETERS sys,gl_sets_of_books sob
2879: WHERE sys.set_of_books_id = sob.set_of_books_id;
2880:
2881: -- Bug 3136127 - if writeoff amount > 0 then max limit must have a value
2882: -- if < 0, then min limit must have a value < 0

Line 3846: l_func_currency gl_sets_of_books.currency_code%TYPE;

3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;
3847: l_activity_name ar_receivables_trx.name%TYPE;
3848: l_ccid NUMBER;
3849:
3850: BEGIN

Line 3958: gl_sets_of_books sob

3954:
3955: SELECT sob.currency_code
3956: INTO l_func_currency
3957: FROM ar_system_parameters sp,
3958: gl_sets_of_books sob
3959: WHERE sp.set_of_books_id = sob.set_of_books_id;
3960:
3961: IF (p_receipt_currency <> p_open_receipt_currency) THEN
3962: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_DIFF_RCT_CURR');