DBA Data[Home] [Help]

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