APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on FA_BOOK_CONTROLS

Line 175: FROM fa_book_controls b

171: b.global_attribute3 last_reval,
172: b.global_attribute5 last_closed_period,
173: b.global_attribute19 last_period_posted
174: INTO p_last_inf_adj,p_last_reval,p_last_closed_period,p_last_period_posted
175: FROM fa_book_controls b
176: WHERE b.book_type_code = p_book_type_code;
177: EXCEPTION
178: WHEN OTHERS THEN
179: RAISE PROGRAM_ERROR;

Line 240: FROM fa_book_controls

236: SELECT global_attribute1,TO_NUMBER(global_attribute2),
237: global_attribute3,TO_NUMBER(global_attribute5)
238: INTO allowed,l_period_counter,
239: l_mass_reval_id,l_period_cont
240: FROM fa_book_controls
241: WHERE book_type_code = p_book_type_code;
242:
243:
244: IF allowed = 'Y' THEN

Line 296: FROM fa_book_controls b, fa_book_controls a

292: SELECT 1
293: INTO dummy
294: FROM dual
295: WHERE NOT EXISTS ( SELECT 1
296: FROM fa_book_controls b, fa_book_controls a
297: WHERE a.book_type_code = p_book_type_code
298: AND DECODE(a.book_class
299: , 'CORPORATE', a.book_type_code
300: , 'TAX' ,a.distribution_source_book) =