APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_ALL_TL

Line 679: , cs_incidents_all_tl tlSR

675: FROM cs_incident_links SrLnkEO
676: , cs_sr_link_types_tl ltype
677: , fnd_user fnd1
678: , cs_incidents_all_b relSR
679: , cs_incidents_all_tl tlSR
680: , cs_incident_statuses_tl status
681: , cs_incident_severities_tl severity
682: WHERE SrLnkEO.subject_id = x_incident_id
683: AND SrLnkEO.subject_type = 'SR'

Line 1022: ,cs_incidents_all_tl tl

1018: ,sr.cp_component_id
1019: ,sr.inv_subcomponent_id
1020: ,sr.incident_location_type
1021: FROM cs_incidents_b_sec sr
1022: ,cs_incidents_all_tl tl
1023: ,csi_item_instances instance
1024: WHERE sr.incident_id = tl.incident_id
1025: AND tl.language = userenv('lang')
1026: AND sr.incident_id = P_Incident_Id

Line 1539: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl

1535: AND resolution.View_APPLICATION_ID = 170
1536: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1537: ,tl.summary Problem_summary
1538: ,tl.resolution_summary Resolution_Summary
1539: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1540: WHERE sr.incident_id = tl.incident_id
1541: AND tl.language = userenv(''lang'')
1542: AND sr.incident_id = :INCIDENT_ID' ;
1543: ELSE