APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_ENCRYPTED_TAGS

Line 97: where incident_id=(select value from iem_encrypted_tags tags,

93: from iem_rt_proc_emails where message_id = l_msg_id;
94:
95: begin
96: select incident_number into l_sr_number from cs_incidents_all_b
97: where incident_id=(select value from iem_encrypted_tags tags,
98: iem_encrypted_tag_dtls dtls where tags.encrypted_id = dtls.encrypted_id
99: and dtls.key = 'IEMNBZTSRVSRID' and tags.message_id= l_msg_id );
100:
101: exception when others then