APPS.ARRX_BSS dependencies on GL_SETS_OF_BOOKS

Line 23: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

19: l_org_where_rah VARCHAR2(4000);
20: l_org_where_rah1 VARCHAR2(4000);
21: l_org_where_ps VARCHAR2(4000);
22: l_org_where_app VARCHAR2(4000);
23: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
24: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
25: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
26: l_count NUMBER;
27: l_balance_due NUMBER;

Line 24: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;

20: l_org_where_rah1 VARCHAR2(4000);
21: l_org_where_ps VARCHAR2(4000);
22: l_org_where_app VARCHAR2(4000);
23: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
24: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
25: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
26: l_count NUMBER;
27: l_balance_due NUMBER;
28: l_functional_balance_due NUMBER;

Line 25: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;

21: l_org_where_ps VARCHAR2(4000);
22: l_org_where_app VARCHAR2(4000);
23: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
24: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
25: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
26: l_count NUMBER;
27: l_balance_due NUMBER;
28: l_functional_balance_due NUMBER;
29: l_applied_amount NUMBER;

Line 97: FROM gl_sets_of_books

93: SELECT currency_code,
94: name
95: INTO l_currency_code,
96: l_sob_name
97: FROM gl_sets_of_books
98: WHERE set_of_books_id = l_books_id;
99:
100: /*------------------------------------------------------------------+
101: | Create Cursors |