DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORY_BOOKS

Line 137: from fa_category_books cb,

133: 'CAPITALIZED')
134: from (select asset_clearing_acct clearing_acct
135: ,book_type_code
136: , 2 acct_type
137: from fa_category_books cb,
138: fa_categories fc
139: where book_type_code = p_book_type_code
140: and cb.category_id = fc.category_id
141: and fc.enabled_flag = 'Y'

Line 144: from fa_category_books cb,

140: and cb.category_id = fc.category_id
141: and fc.enabled_flag = 'Y'
142: UNION
143: select cip_clearing_acct , book_type_code, 1
144: from fa_category_books cb,
145: fa_categories fc
146: where cip_clearing_acct is not null
147: and book_type_code = p_book_type_code
148: and cb.category_id = fc.category_id

Line 166: from fa_category_books cb,

162: 'CAPITALIZED')
163: from (select asset_clearing_acct clearing_acct
164: ,cb.book_type_code
165: ,2 acct_type
166: from fa_category_books cb,
167: fa_book_controls bc,
168: fa_categories fc
169: where cb.book_type_code = bc.book_type_code
170: and bc.book_class = 'CORPORATE'

Line 178: from fa_category_books cb,

174: UNION
175: select cip_clearing_acct
176: ,cb.book_type_code
177: ,1
178: from fa_category_books cb,
179: fa_book_controls bc,
180: fa_categories fc
181: where cip_clearing_acct is not null
182: and cb.book_type_code = bc.book_type_code