DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on CS_INCIDENT_STATUSES_VL

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

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