APPS.AHL_COMPLEX_MX_PVT dependencies on CSI_II_RELATIONSHIPS

Line 625: FROM csi_ii_relationships

621: AND NVL(B.status_code,'INIT-DUE') = 'INIT-DUE'
622: --AND B.preceding_ue_id IS NULL
623: AND B.csi_item_instance_id IN
624: (SELECT subject_id
625: FROM csi_ii_relationships
626: WHERE 1 =1
627: START WITH object_id =c_instance_id
628: AND relationship_type_code = 'COMPONENT-OF'
629: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 706: FROM csi_ii_relationships

702: WHERE visit.status_code <> 'CLOSED'
703: AND TRUNC(Get_Visit_End_Date(visit.visit_id)) BETWEEN p_from_dt AND p_to_dt
704: AND visit.item_instance_id IN
705: (SELECT object_id
706: FROM csi_ii_relationships
707: WHERE 1 =1
708: START WITH subject_id = p_instance_id
709: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
710: CONNECT BY PRIOR object_id = subject_id

Line 999: FROM csi_ii_relationships

995:
996: CURSOR Get_Child_Instances(c_instance_id NUMBER) IS
997: SELECT object_id, subject_id, position_reference, level, relationship_id csi_ii_relationship_id,
998: object_version_number csi_ii_object_version_number
999: FROM csi_ii_relationships
1000: START WITH object_id = c_instance_id
1001: AND relationship_type_code = 'COMPONENT-OF'
1002: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1003: CONNECT BY PRIOR subject_id = object_id