APPS.IGI_IMP_IAC_EXPORT_PKG SQL Statements

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

Line: 69

   	Select distinct group_id from igi_imp_iac_interface
   	where book_type_code = p_book and
   	      category_id = p_category_id;

Line: 236

		/* Update the igi_imp_iac_interface table with  the export details  */
		update igi_imp_iac_interface set export_file=l_fname_with_locn ,export_date=trunc(sysdate)
		where book_type_code = p_book and
     	              category_id = p_category_id  and
     	              group_id =l_get_groups.group_id;