241: sp1.base_currency_code base_currency_code,
242: sob1.name name ,
243: sob1.short_name short_name,
244: ap1.displayed_field displayed_field
245: FROM gl_sets_of_books sob1, ap_system_parameters sp1,
246: ap_lookup_codes ap1
247: WHERE sob1.set_of_books_id <> -1
248: AND ap1.lookup_code = sp1.accounting_method_option
249: AND ap1.lookup_type = 'ACCOUNTING BASIS METHOD'
255: sp2.base_currency_code base_currency_code,
256: sob2.name name ,
257: sob2.short_name short_name,
258: ap2.displayed_field displayed_field
259: FROM gl_sets_of_books sob2, ap_system_parameters sp2,
260: ap_lookup_codes ap2
261: WHERE sob2.set_of_books_id <> -1
262: AND ap2.lookup_code = sp2.secondary_accounting_method
263: AND ap2.lookup_type = 'ACCOUNTING BASIS METHOD'