APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_ENCRYPTED_TAG_DTLS

Line 98: iem_encrypted_tag_dtls dtls where tags.encrypted_id = dtls.encrypted_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
102: l_sr_number := null;