APPS.IEM_EMAIL_PROC_PVT dependencies on CS_INCIDENTS_ALL_B

Line 2139: from cs_incidents_all_b where incident_id=l_sr_id;

2135: l_activity_rec.DOC_REF := 'SR';
2136: -- Added l_activity_rec.doc_source_object_name for bug 9169782
2137: -- Changed by Sanjana Rao on 08-Jan-2010
2138: select incident_number into l_activity_rec.doc_source_object_name
2139: from cs_incidents_all_b where incident_id=l_sr_id;
2140:
2141:
2142: if g_statement_log then
2143: l_logmessage:='CAlling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR';

Line 3883: 'select object_version_number,status_flag from cs_incidents_all_b where incident_id=:sr_id' using p_sr_id;

3879: x_status:='S';
3880: -- select object version number
3881: BEGIN
3882: open c1 for
3883: 'select object_version_number,status_flag from cs_incidents_all_b where incident_id=:sr_id' using p_sr_id;
3884: LOOP
3885: fetch c1 into l_object_version_number,l_status_flag;
3886: exit;
3887: end loop;