DBA Data[Home] [Help]

APPS.XLA_XLAIQACL_UTILS_PKG dependencies on AP_LOOKUP_CODES

Line 228: FROM ap_sob_info_v v, gl_sets_of_books sob, ap_lookup_codes ap

224: /* CURSOR ap_acct_method_sob_c IS
225: SELECT v.set_of_books_id, v.sob_type, v.accounting_method,
226: v.base_currency_code, v.name, sob.short_name,
227: ap.displayed_field
228: FROM ap_sob_info_v v, gl_sets_of_books sob, ap_lookup_codes ap
229: WHERE v.set_of_books_id <> -1
230: AND sob.set_of_books_id = v.set_of_books_id
231: AND v.accounting_method = ap.lookup_code
232: AND ap.lookup_type = 'ACCOUNTING BASIS METHOD';

Line 246: ap_lookup_codes ap1

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'
250: AND sob1.set_of_books_id = sp1.set_of_books_id

Line 260: ap_lookup_codes ap2

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'
264: AND sob2.set_of_books_id = sp2.secondary_set_of_books_id;