APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_SYSTEM_PARAMETERS

Line 1484: ar_system_parameters sp

1480: CURSOR c_period_name IS
1481: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1482: gps.period_name
1483: from gl_period_statuses gps,
1484: ar_system_parameters sp
1485: where gps.application_id = 222
1486: and gps.adjustment_period_flag = 'N'
1487: and gps.set_of_books_id = sp.set_of_books_id
1488: and p_gl_date between gps.start_date and gps.end_date;

Line 1668: FROM ar_system_parameters sp,

1664: SELECT sp.code_combination_id_gain,
1665: sb.currency_code
1666: INTO l_code_combination_id_gain,
1667: l_base_currency
1668: FROM ar_system_parameters sp,
1669: gl_sets_of_books sb
1670: WHERE sp.set_of_books_id = sb.set_of_books_id;
1671:
1672: ELSE