APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_INCIDENT_TYPES_B

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))) ),