APPS.IEM_UTILITY_PVT SQL Statements

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

Line: 13

	cursor c1 is select email_account_id,from_name from iem_mstemail_accounts where deleted_flag<>'Y'
	order by from_name;

Line: 25

SAVEPOINT select_mail_count_pvt;

Line: 45

	ROLLBACK TO select_mail_count_PVT;

Line: 52

	ROLLBACK TO select_mail_count_PVT;

Line: 59

	ROLLBACK TO select_mail_count_PVT;

Line: 87

		select a.route_classification_id,b.name from iem_account_route_class a,iem_route_classifications b
    		where a.route_classification_id=b.route_classification_id and a.enabled_flag='Y'
    		and a.email_account_id=p_email_account_id
		order by 2;

Line: 102

SAVEPOINT select_mail_count_pvt;

Line: 122

	ROLLBACK TO select_mail_count_PVT;

Line: 129

	ROLLBACK TO select_mail_count_PVT;

Line: 136

	ROLLBACK TO select_mail_count_PVT;

Line: 166

	select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
	where resource_id=p_resource_id;