APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on CSI_II_RELATIONSHIPS

Line 910: FROM csi_ii_relationships root

906: IS
907:
908: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
909: SELECT root.object_id
910: FROM csi_ii_relationships root
911: WHERE NOT EXISTS (SELECT 'x'
912: FROM csi_ii_relationships
913: WHERE subject_id = root.object_id
914: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 912: FROM csi_ii_relationships

908: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
909: SELECT root.object_id
910: FROM csi_ii_relationships root
911: WHERE NOT EXISTS (SELECT 'x'
912: FROM csi_ii_relationships
913: WHERE subject_id = root.object_id
914: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
915: )
916: START WITH root.subject_id = p_instance_id

Line 953: FROM csi_ii_relationships

949: IS
950:
951: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
952: SELECT subject_id , object_id, position_reference
953: FROM csi_ii_relationships
954: START WITH object_id = p_csi_root_instance_id
955: AND relationship_type_code = 'COMPONENT-OF'
956: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
957: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))