APPS.CS_SR_COST_CP dependencies on CS_INCIDENT_STATUSES
Line 1491: ,cs_incident_statuses cis
1487:
1488: CURSOR get_estimate_id IS
1489: SELECT ced.estimate_detail_id
1490: FROM cs_incidents_all_b cia 1491: ,cs_incident_statuses cis 1492: ,cs_estimate_details ced
1493: WHERE Nvl(cis.close_flag,'N') IN (decode( p_sr_status,'OPEN','N','CLOSED','Y' ,'ALL',Nvl(cis.close_flag,'N')))
1494: and cis.incident_subtype='INC'
1495: and cia.incident_status_id = cis.incident_status_id