APPS.AHL_UMP_UTIL_PKG dependencies on DUAL

Line 691: FROM DUAL) cs

687: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
688: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
689: UNION ALL
690: SELECT p_item_instance_id
691: FROM DUAL) cs
692: WHERE amr.mr_header_id = p_mr_id
693: AND amr.csi_item_instance_id = cs.subject_id;
694: */
695: /* performance fix.

Line 708: FROM DUAL)

704: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
705: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
706: UNION ALL
707: SELECT p_item_instance_id csi_item_instance_id
708: FROM DUAL)
709: SELECT csi_item_instance_id
710: FROM INST
711: WHERE EXISTS (SELECT 'x'
712: FROM ahl_applicable_mrs AMR

Line 733: FROM DUAL

729: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
730: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
731: UNION ALL
732: SELECT p_item_instance_id csi_item_instance_id
733: FROM DUAL
734: WHERE EXISTS (SELECT 'x'
735: FROM ahl_applicable_mrs AMR
736: WHERE amr.mr_header_id = p_mr_id
737: AND amr.csi_item_instance_id = p_item_instance_id);