APPS.IBY_ACCTTYPE_PKG SQL Statements

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

Line: 16

select iby_accttype_s.nextval
from dual;

Line: 21

 SELECT accttypeid
 FROM iby_accttype
 WHERE accttype = ci_accttype
 AND instrtype = ci_instrtype;

Line: 51

** insert name in the database.
*/
        INSERT INTO iby_accttype ( accttypeid, accttype, instrtype,
				last_update_date, last_updated_by,
				creation_date, created_by,
				last_update_login, object_version_number)
        VALUES ( l_accttypeid, i_accttype, i_instrtype,
		 sysdate, fnd_global.user_id,
		 sysdate, fnd_global.user_id,
		fnd_global.login_id, 1);