APPS.AHL_COMPLEX_MX_PVT dependencies on DUAL

Line 637: FROM dual -- incliude the root instance id also

633:
634: UNION
635:
636: SELECT c_instance_id AS subject_id
637: FROM dual -- incliude the root instance id also
638: );
639:
640: BEGIN
641: /* sthilak back port #13488050 */

Line 714: SELECT p_instance_id object_id FROM dual

710: CONNECT BY PRIOR object_id = subject_id
711: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
712: UNION
713:
714: SELECT p_instance_id object_id FROM dual
715: )
716: AND IS_RTS_VISIT(p_instance_id,visit.visit_id) = 1;
717: RETURN l_have_visit;
718: END;