DBA Data[Home] [Help]

APPS.AHL_UC_UTILIZATION_PVT dependencies on DUAL

Line 1481: FROM DUAL

1477: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1478: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate)
1479: AND CCCV.CUSTOMER_PRODUCT_ID IN (SELECT c_instance_id
1480: */
1481: FROM DUAL
1482: UNION ALL
1483: SELECT subject_id
1484: FROM csi_ii_relationships CI
1485: START WITH object_id = c_instance_id