APPS.JAI_PO_V_TRIGGER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

     select Currency_code
       from gl_sets_of_books
      where set_of_books_id = V_SET_OF_BOOKS_ID;

Line: 70

     UPDATE JAI_CMN_VENDOR_SITES
     SET    inactive_flag = 'Y'
     WHERE  vendor_id  = pr_new.vendor_id
     AND    vendor_site_id = 0 ;

Line: 75

     UPDATE JAI_CMN_VENDOR_SITES
     SET    inactive_flag = ''
     WHERE  vendor_id  = pr_new.vendor_id
     AND    vendor_site_id = 0 ;