IGI Reason Code Listing - draft

select  reason_code, je.description, je.set_of_books_id, start_date_active, end_date_active, name
from igi_bud_reason_codes je,  gl_sets_of_books gl
WHERE  je.set_of_books_id = gl.set_of_books_id
and  je.SET_OF_BOOKS_ID = :P_SOB_ID
ORDER BY  upper(reason_code)

select reason_code, je.description, je.set_of_books_id, start_date_active, end_date_active, name from igi_bud_reason_codes je, gl_sets_of_books gl WHERE je.set_of_books_id = gl.set_of_books_id and je.SET_OF_BOOKS_ID = :P_SOB_ID ORDER BY upper(reason_code)