APPS.IEM_EMTA_ACCT_PVT SQL Statements

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

Line: 17

G_created_updated_by   NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line: 18

G_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

Line: 50

  l_is_acct_updated varchar2(1);

Line: 82

	 --select user_name, user_password, encrypt_key, in_host, in_port
	 select user_name, in_host, in_port,ssl_connection_flag
	 into  l_user_name, l_in_host, l_in_port,l_ssl_connection_flag
	 from iem_mstemail_accounts where email_account_id = p_email_account_id ;

Line: 127

        ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;