DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on GL_SETS_OF_BOOKS

Line 170: gl_sets_of_books gls,

166: gls.set_of_books_id,
167: mbc.primary_currency_code,
168: bc.book_class
169: FROM
170: gl_sets_of_books gls,
171: fa_book_controls bc,
172: fa_mc_book_controls mbc
173: WHERE
174: mbc.book_type_code = p_book_type_code AND

Line 1466: gl_sets_of_books gls,

1462: gls.ret_earn_code_combination_id
1463: INTO G_coa_id,
1464: G_re_ccid
1465: FROM
1466: gl_sets_of_books gls,
1467: fa_mc_book_controls bc
1468: WHERE
1469: bc.book_type_code = p_book_type_code AND
1470: bc.set_of_books_id = p_rsob_id AND

Line 1678: to be out of balance. We use the template RE ccid in gl_sets_of_books

1674: given balancing segment. After all the CCID balances have been obtained
1675: and inserted into GL_INTERFACE, we will have to balance each balancing
1676: segment. This is because we do not obtain the balances of revenue/expense
1677: accounts for past years and this will cause the entries in GL_INTERFACE
1678: to be out of balance. We use the template RE ccid in gl_sets_of_books
1679: in the dynamic sql and group by the balancing segment to create the plug
1680: to the correct retained earning account.
1681: ************************************************************************ */
1682: