APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_II_RELATIONSHIPS

Line 923: FROM csi_ii_relationships

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

Line 1200: FROM csi_ii_relationships CI

1196: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1197: -- Removed the use of csi_cp_counters_v
1198: CURSOR get_components_counter(c_instance_id NUMBER, c_counter_name VARCHAR2) IS
1199: SELECT CI.subject_id
1200: FROM csi_ii_relationships CI
1201: WHERE EXISTS (SELECT 'X'
1202: /*
1203: FROM cs_counters CC,
1204: cs_counter_groups CG

Line 1237: FROM csi_ii_relationships

1233: AND relationship_type_code = 'COMPONENT-OF';
1234:
1235: CURSOR get_all_ancestors(c_desc_instance_id NUMBER, c_ance_instance_id NUMBER) IS
1236: SELECT object_id
1237: FROM csi_ii_relationships
1238: START WITH subject_id = c_desc_instance_id
1239: AND object_id <> c_ance_instance_id
1240: -- This condition is really required because of the extreme case in which
1241: -- subject_id = c_desc_instance_id and object_id happens to be c_ance_instance_id

Line 1453: FROM csi_ii_relationships CI

1449: AND CCA.SOURCE_OBJECT_ID IN (SELECT c_instance_id
1450: FROM DUAL
1451: UNION ALL
1452: SELECT subject_id
1453: FROM csi_ii_relationships CI
1454: START WITH object_id = c_instance_id
1455: AND trunc(nvl(CI.active_start_date,sysdate)) <= trunc(sysdate)
1456: AND trunc(nvl(CI.active_end_date,sysdate+1)) > trunc(sysdate)
1457: AND CI.relationship_type_code = 'COMPONENT-OF'

Line 1567: FROM csi_ii_relationships

1563: CURSOR get_ancestors(c_start_instance_id NUMBER, c_desc_instance_id NUMBER) IS
1564: SELECT object_id,
1565: subject_id,
1566: to_number(position_reference) relationship_id
1567: FROM csi_ii_relationships
1568: START WITH subject_id = c_desc_instance_id
1569: AND relationship_type_code = 'COMPONENT-OF'
1570: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1571: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)