DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 2544: select cia.incident_id from cs_incidents_vl_sec cia,CS_INCIDENT_STATUSES_VL cis

2540: into l_sr_exists
2541: from dual
2542: where exists
2543: (
2544: select cia.incident_id from cs_incidents_vl_sec cia,CS_INCIDENT_STATUSES_VL cis
2545: where cia.customer_product_id = l_instance_id
2546: and cia.incident_status_id = cis.incident_status_id
2547: and nvl(cis.close_flag,'N') <> 'Y'
2548: and cis.language = userenv('lang')