DBA Data[Home] [Help]

APPS.CS_SR_UTIL_PKG dependencies on CS_INCIDENT_TYPES_RG_V_SEC

Line 133: FROM cs_incident_types_rg_v_sec

129: p_default_type_workflow,
130: p_default_type_cnt
131: -- 11.5.10. Changed to look at the secured view. rmanabat, 12/03/03
132: --FROM cs_incident_types_rg_v
133: FROM cs_incident_types_rg_v_sec
134: WHERE incident_type_id = p_default_type_id
135: AND incident_subtype = 'INC'
136: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
137: AND trunc(nvl(end_date_active, sysdate));

Line 308: FROM cs_incident_types_rg_v_sec

304: p_default_type_maint_flag,
305: p_default_cmro_flag
306: -- 11.5.10. Changed to look at the secured view. rmanabat, 12/03/03
307: --FROM cs_incident_types_rg_v
308: FROM cs_incident_types_rg_v_sec
309: WHERE incident_type_id = p_default_type_id
310: AND incident_subtype = 'INC'
311: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
312: AND trunc(nvl(end_date_active, sysdate));