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 655: gl_sets_of_books sob

651: Begin
652: SELECT distinct sob.currency_code
653: INTO g_curr_rec.base_currency
654: FROM ar_system_parameters sysp,
655: gl_sets_of_books sob
656: WHERE sob.set_of_books_id = sysp.set_of_books_id;
657: Exception when others then
658: g_curr_rec.base_currency := NULL;
659: End;

Line 1039: gl_sets_of_books sob

1035: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
1036: /* SELECT sob.currency_code
1037: INTO g_curr_rec.base_currency
1038: FROM ar_system_parameters sysp,
1039: gl_sets_of_books sob
1040: WHERE sob.set_of_books_id = sysp.set_of_books_id;
1041:
1042: -- Past Year From and To
1043: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,