APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_II_RELATIONSHIPS

Line 927: FROM csi_ii_relationships

923: --instance
924: PROCEDURE update_reading_ins(p_utilization_rec IN utilization_rec_type) IS
925: CURSOR csi_relationships_csr(c_csi_item_instance_id NUMBER) IS
926: SELECT subject_id csi_item_instance_id, position_reference
927: FROM csi_ii_relationships
928: START WITH object_id = c_csi_item_instance_id
929: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
930: AND trunc(nvl(active_end_date,sysdate+1)) > trunc(sysdate)
931: AND relationship_type_code = 'COMPONENT-OF'

Line 1212: FROM csi_ii_relationships CI

1208: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1209: -- Removed the use of csi_cp_counters_v
1210: CURSOR get_components_counter(c_instance_id NUMBER, c_counter_name VARCHAR2) IS
1211: SELECT CI.subject_id
1212: FROM csi_ii_relationships CI
1213: WHERE EXISTS (SELECT 'X'
1214: /*
1215: FROM cs_counters CC,
1216: cs_counter_groups CG

Line 1249: FROM csi_ii_relationships

1245: AND relationship_type_code = 'COMPONENT-OF';
1246:
1247: CURSOR get_all_ancestors(c_desc_instance_id NUMBER, c_ance_instance_id NUMBER) IS
1248: SELECT object_id
1249: FROM csi_ii_relationships
1250: START WITH subject_id = c_desc_instance_id
1251: AND object_id <> c_ance_instance_id
1252: -- This condition is really required because of the extreme case in which
1253: -- subject_id = c_desc_instance_id and object_id happens to be c_ance_instance_id

Line 1484: FROM csi_ii_relationships CI

1480: */
1481: FROM DUAL
1482: UNION ALL
1483: SELECT subject_id
1484: FROM csi_ii_relationships CI
1485: START WITH object_id = c_instance_id
1486: AND trunc(nvl(CI.active_start_date,sysdate)) <= trunc(sysdate)
1487: AND trunc(nvl(CI.active_end_date,sysdate+1)) > trunc(sysdate)
1488: AND CI.relationship_type_code = 'COMPONENT-OF'

Line 1598: FROM csi_ii_relationships

1594: CURSOR get_ancestors(c_start_instance_id NUMBER, c_desc_instance_id NUMBER) IS
1595: SELECT object_id,
1596: subject_id,
1597: to_number(position_reference) relationship_id
1598: FROM csi_ii_relationships
1599: START WITH subject_id = c_desc_instance_id
1600: AND relationship_type_code = 'COMPONENT-OF'
1601: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1602: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)