APPS.FA_FIN_ADD_PKG dependencies on FA_BOOK_CONTROLS

Line 84: from fa_book_controls

80: -- and inserted rownum condition.
81:
82: select count(1)
83: into lv_count
84: from fa_book_controls
85: where book_type_code = X_BOOK_TYPE_CODE
86: and nvl(date_ineffective, sysdate+1) > sysdate
87: and rownum < 2;
88: --

Line 135: from fa_books bk, fa_book_controls bc

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

Line 168: from fa_book_controls

164: --
165:
166: select accounting_flex_structure
167: into X_ACCT_FLEX_NUM
168: from fa_book_controls
169: where book_type_code = X_BOOK_TYPE_CODE;
170: --
171: EXCEPTION
172: when validation_error then

Line 234: fa_book_controls bc

230: -- check prorate date
231: select count(*)
232: into lv_count
233: from fa_calendar_periods cp,
234: fa_book_controls bc
235: where bc.book_type_code = X_BOOK_TYPE_CODE
236: and bc.prorate_calendar = cp.calendar_type
237: and X_PRORATE_DATE between cp.start_date and cp.end_date;
238: --