DBA Data[Home] [Help]

APPS.IEM_CLIENTLAUNCH_PUB dependencies on CS_INCIDENTS_ALL_B

Line 96: select incident_number into l_sr_number from cs_incidents_all_b

92: select rt_classification_id,customer_id,nvl(contact_id,-1) into l_classification_id,l_cust_id,l_contact_id
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: