APPS.IEM_CLIENTLAUNCH_PUB SQL Statements

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

Line: 89

            select route_classification_id into l_classification_id from iem_account_route_class
            where account_route_class_id = l_acct_rt_class_id;

Line: 92

	    select rt_classification_id,customer_id,nvl(contact_id,-1)  into l_classification_id,l_cust_id,l_contact_id
	    from iem_rt_proc_emails where message_id = l_msg_id;

Line: 96

		select incident_number into l_sr_number from cs_incidents_all_b
		where incident_id=(select value from iem_encrypted_tags tags,
		iem_encrypted_tag_dtls dtls where tags.encrypted_id = dtls.encrypted_id
		and dtls.key = 'IEMNBZTSRVSRID' and tags.message_id= l_msg_id );

Line: 214

        select route_classification_id, name
            into l_classification_id, l_class_name
            --from iem_route_classifications a, iem_post_mdts b
            from iem_route_classifications a, iem_rt_proc_emails b
            where a.route_classification_id = b.rt_classification_id
            and b.message_id = l_msg_id;

Line: 221

        select rt_media_item_id
            into l_rt_media_item_id
            from IEM_RT_MEDIA_ITEMs
            where message_id = l_msg_id
		  and expire='N';