APPS.FA_FASUNPLD_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 28: gl_sets_of_books sob

24: min_au,
25: descr
26: FROM fnd_currencies_vl c,
27: fa_book_controls bc,
28: gl_sets_of_books sob
29: WHERE bc.book_type_code = P_ASSET_BOOK_TYPE
30: AND sob.set_of_books_id = bc.set_of_books_id
31: AND c.currency_code = sob.currency_code ;
32:

Line 229: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

225: END; return (TRUE);
226: end;
227:
228: FUNCTION get_company_name RETURN BOOLEAN IS
229: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
230: l_name gl_sets_of_books.name%TYPE;
231: l_sob_id number;
232: BEGIN
233:

Line 230: l_name gl_sets_of_books.name%TYPE;

226: end;
227:
228: FUNCTION get_company_name RETURN BOOLEAN IS
229: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
230: l_name gl_sets_of_books.name%TYPE;
231: l_sob_id number;
232: BEGIN
233:
234: if P_SET_OF_BOOKS_ID is not null then

Line 240: FROM gl_sets_of_books

236: SELECT name,
237: chart_of_accounts_id
238: INTO l_name,
239: l_chart_of_accounts_id
240: FROM gl_sets_of_books
241: WHERE set_of_books_id = l_sob_id;
242:
243: c_company_name_header := l_name;
244: c_chart_of_accounts_id := l_chart_of_accounts_id;