APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on CSI_II_RELATIONSHIPS

Line 887: FROM csi_ii_relationships root

883: IS
884:
885: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
886: SELECT root.object_id
887: FROM csi_ii_relationships root
888: WHERE NOT EXISTS (SELECT 'x'
889: FROM csi_ii_relationships
890: WHERE subject_id = root.object_id
891: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 889: FROM csi_ii_relationships

885: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
886: SELECT root.object_id
887: FROM csi_ii_relationships root
888: WHERE NOT EXISTS (SELECT 'x'
889: FROM csi_ii_relationships
890: WHERE subject_id = root.object_id
891: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
892: )
893: START WITH root.subject_id = p_instance_id

Line 930: FROM csi_ii_relationships

926: IS
927:
928: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
929: SELECT subject_id , object_id, position_reference
930: FROM csi_ii_relationships
931: START WITH object_id = p_csi_root_instance_id
932: AND relationship_type_code = 'COMPONENT-OF'
933: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
934: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))