APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_INCIDENT_TYPES

Line 563: cs_incident_types

559: cursor c_biz_process is
560: select
561: business_process_id
562: from
563: cs_incident_types
564: where
565: incident_type_id = p_inc_type_id;
566: --
567: cursor c_contact is

Line 1648: FROM CS_INCIDENT_TYPES_B

1644: and responsibility_id = P_RESP_ID
1645: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))
1646: AND TRUNC(NVL(END_DATE,SYSDATE))),
1647: NULL,DECODE((select status_group_id
1648: FROM CS_INCIDENT_TYPES_B
1649: where incident_type_id = P_INCIDENT_TYPE_ID
1650: and incident_subtype = 'INC'
1651: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE))
1652: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))),NULL,null,(select status_group_id

Line 1653: FROM CS_INCIDENT_TYPES_B

1649: where incident_type_id = P_INCIDENT_TYPE_ID
1650: and incident_subtype = 'INC'
1651: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE))
1652: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))),NULL,null,(select status_group_id
1653: FROM CS_INCIDENT_TYPES_B
1654: where incident_type_id = P_INCIDENT_TYPE_ID
1655: and incident_subtype = 'INC'
1656: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE))
1657: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) ),