APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on DUAL

Line 1664: FROM DUAL) ST,

1660: WHERE INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID
1661: and responsibility_id =P_RESP_ID
1662: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))
1663: AND TRUNC(NVL(END_DATE,SYSDATE))) ) STATUS_GROUP_ID
1664: FROM DUAL) ST,
1665: CS_SR_STATUS_GROUPS_B B
1666: WHERE b.STATUS_GROUP_ID =st.status_group_id
1667: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE)) AND TRUNC(NVL(END_DATE,SYSDATE))
1668: ) FT;