APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_ALL_TL

Line 663: , cs_incidents_all_tl tlSR

659: FROM cs_incident_links SrLnkEO
660: , cs_sr_link_types_tl ltype
661: , fnd_user fnd1
662: , cs_incidents_all_b relSR
663: , cs_incidents_all_tl tlSR
664: , cs_incident_statuses_tl status
665: , cs_incident_severities_tl severity
666: WHERE SrLnkEO.subject_id = x_incident_id
667: AND SrLnkEO.subject_type = 'SR'

Line 951: ,cs_incidents_all_tl tl

947: ,sr.cp_component_id
948: ,sr.inv_subcomponent_id
949: ,sr.incident_location_type
950: FROM cs_incidents_b_sec sr
951: ,cs_incidents_all_tl tl
952: ,csi_item_instances instance
953: WHERE sr.incident_id = tl.incident_id
954: AND tl.language = userenv('lang')
955: AND sr.incident_id = P_Incident_Id

Line 1463: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl

1459: AND resolution.View_APPLICATION_ID = 170
1460: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1461: ,tl.summary Problem_summary
1462: ,tl.resolution_summary Resolution_Summary
1463: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1464: WHERE sr.incident_id = tl.incident_id
1465: AND tl.language = userenv(''lang'')
1466: AND sr.incident_id = :INCIDENT_ID' ;
1467: ELSE