APPS.FA_FIN_ADD_PKG dependencies on FA_BOOK_CONTROLS

Line 89: from fa_book_controls

85: -- and inserted rownum condition.
86:
87: select count(1)
88: into lv_count
89: from fa_book_controls
90: where book_type_code = X_BOOK_TYPE_CODE
91: and nvl(date_ineffective, sysdate+1) > sysdate
92: and rownum < 2;
93: --

Line 140: from fa_books bk, fa_book_controls bc

136: -- syoung: performance tuning: count(*) to count(1)
137: -- and inserted rownum condition.
138: select count(1)
139: into lv_count
140: from fa_books bk, fa_book_controls bc
141: where bk.asset_id= X_ASSET_ID
142: and bk.book_type_code <> X_BOOK_TYPE_CODE
143: and bk.date_ineffective is null
144: and bk.book_type_code = bc.book_type_code

Line 173: from fa_book_controls

169: --
170:
171: select accounting_flex_structure
172: into X_ACCT_FLEX_NUM
173: from fa_book_controls
174: where book_type_code = X_BOOK_TYPE_CODE;
175: --
176: EXCEPTION
177: when validation_error then

Line 242: fa_book_controls bc

238: -- check prorate date
239: select count(*)
240: into lv_count
241: from fa_calendar_periods cp,
242: fa_book_controls bc
243: where bc.book_type_code = X_BOOK_TYPE_CODE
244: and bc.prorate_calendar = cp.calendar_type
245: and X_PRORATE_DATE between cp.start_date and cp.end_date;
246: --