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 1457: gl_sets_of_books gls,

1453: gls.ret_earn_code_combination_id
1454: INTO G_coa_id,
1455: G_re_ccid
1456: FROM
1457: gl_sets_of_books gls,
1458: fa_mc_book_controls bc
1459: WHERE
1460: bc.book_type_code = p_book_type_code AND
1461: bc.set_of_books_id = p_rsob_id AND

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

1665: given balancing segment. After all the CCID balances have been obtained
1666: and inserted into GL_INTERFACE, we will have to balance each balancing
1667: segment. This is because we do not obtain the balances of revenue/expense
1668: accounts for past years and this will cause the entries in GL_INTERFACE
1669: to be out of balance. We use the template RE ccid in gl_sets_of_books
1670: in the dynamic sql and group by the balancing segment to create the plug
1671: to the correct retained earning account.
1672: ************************************************************************ */
1673: