APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_SYSTEM_PARAMETERS

Line 1394: ar_system_parameters sp

1390: CURSOR c_period_name IS
1391: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1392: gps.period_name
1393: from gl_period_statuses gps,
1394: ar_system_parameters sp
1395: where gps.application_id = 222
1396: and gps.adjustment_period_flag = 'N'
1397: and gps.set_of_books_id = sp.set_of_books_id
1398: and p_gl_date between gps.start_date and gps.end_date;

Line 1578: FROM ar_system_parameters sp,

1574: SELECT sp.code_combination_id_gain,
1575: sb.currency_code
1576: INTO l_code_combination_id_gain,
1577: l_base_currency
1578: FROM ar_system_parameters sp,
1579: gl_sets_of_books sb
1580: WHERE sp.set_of_books_id = sb.set_of_books_id;
1581:
1582: ELSE