APPS.AHL_UMP_UTIL_PKG dependencies on DUAL

Line 863: FROM DUAL) cs

859: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
860: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
861: UNION ALL
862: SELECT p_item_instance_id
863: FROM DUAL) cs
864: WHERE amr.mr_header_id = p_mr_id
865: AND amr.csi_item_instance_id = cs.subject_id;
866: */
867: /* performance fix.

Line 880: FROM DUAL)

876: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
877: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
878: UNION ALL
879: SELECT p_item_instance_id csi_item_instance_id
880: FROM DUAL)
881: SELECT csi_item_instance_id
882: FROM INST
883: WHERE EXISTS (SELECT 'x'
884: FROM ahl_applicable_mrs AMR

Line 906: FROM DUAL

902: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
903: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
904: UNION ALL
905: SELECT p_item_instance_id csi_item_instance_id
906: FROM DUAL
907: WHERE EXISTS (SELECT 'x'
908: FROM ahl_applicable_mrs AMR
909: WHERE amr.mr_header_id = p_mr_id
910: AND amr.csi_item_instance_id = p_item_instance_id);

Line 925: FROM DUAL

921: START WITH object_id = p_item_instance_id
922: CONNECT BY PRIOR subject_id = object_id
923: UNION ALL
924: SELECT p_item_instance_id csi_item_instance_id
925: FROM DUAL
926: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
927: FROM ahl_applicable_mrs AMR
928: WHERE amr.mr_header_id = p_mr_id
929: AND amr.csi_item_instance_id = p_item_instance_id);

Line 938: FROM DUAL

934: CURSOR ahl_appl_ii_csr(p_mr_id IN NUMBER,
935: p_item_instance_id IN NUMBER) IS
936:
937: SELECT p_item_instance_id csi_item_instance_id
938: FROM DUAL
939: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
940: FROM ahl_applicable_mrs AMR
941: WHERE amr.mr_header_id = p_mr_id
942: AND amr.csi_item_instance_id = p_item_instance_id);

Line 957: FROM DUAL

953: WHERE amr.mr_header_id = p_mr_id
954: AND amr.csi_item_instance_id = cmp.subject_id)
955: UNION ALL
956: SELECT p_item_instance_id subject_id
957: FROM DUAL
958: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
959: FROM ahl_applicable_mrs AMR
960: WHERE amr.mr_header_id = p_mr_id
961: AND amr.csi_item_instance_id = p_item_instance_id);