APPS.IEX_PROFILE dependencies on GL_SETS_OF_BOOKS

Line 9: base_currency gl_sets_of_books.currency_code%TYPE ,

5: PG_DEBUG NUMBER;
6: g_line varchar2(100);
7: TYPE curr_rec_type IS RECORD (
8: set_of_books_id ar_system_parameters.set_of_books_id%TYPE ,
9: base_currency gl_sets_of_books.currency_code%TYPE ,
10: past_year_from DATE,
11: past_year_to DATE
12: );
13:

Line 537: gl_sets_of_books sob

533: Begin
534: SELECT distinct sob.currency_code
535: INTO g_curr_rec.base_currency
536: FROM ar_system_parameters sysp,
537: gl_sets_of_books sob
538: WHERE sob.set_of_books_id = sysp.set_of_books_id;
539: Exception when others then
540: g_curr_rec.base_currency := NULL;
541: End;

Line 850: gl_sets_of_books sob

846: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
847: /* SELECT sob.currency_code
848: INTO g_curr_rec.base_currency
849: FROM ar_system_parameters sysp,
850: gl_sets_of_books sob
851: WHERE sob.set_of_books_id = sysp.set_of_books_id;
852:
853: -- Past Year From and To
854: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,