APPS.AHL_UC_UTILIZATION_PVT dependencies on CS_COUNTER_GROUPS

Line 387: FROM cs_counters ctr, cs_counter_groups cgrp

383:
384: -- Validate Counter ID.
385: CURSOR cs_counters_csr (c_counter_id NUMBER) IS
386: SELECT cgrp.source_object_id
387: FROM cs_counters ctr, cs_counter_groups cgrp
388: WHERE cgrp.counter_group_id = ctr.counter_group_id
389: AND cgrp.source_object_code = 'CP'
390: AND ctr.counter_id = c_counter_id
391: AND trunc(sysdate) >= trunc(nvl(ctr.start_date_active,sysdate))

Line 1207: Cannot use cs_counters and cs_counter_groups anymore **/

1203:
1204: PROCEDURE update_reading_cn(p_utilization_rec IN utilization_rec_type) IS
1205: TYPE instance_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1206: /** Begin changes by jaramana on October 29, 2007 for bug 6513576
1207: Cannot use cs_counters and cs_counter_groups anymore **/
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

Line 1216: cs_counter_groups CG

1212: FROM csi_ii_relationships CI
1213: WHERE EXISTS (SELECT 'X'
1214: /*
1215: FROM cs_counters CC,
1216: cs_counter_groups CG
1217: WHERE CC.counter_group_id = CG.counter_group_id
1218: AND CG.source_object_id = CI.subject_id
1219: AND CG.source_object_code = 'CP'
1220: AND CC.name = c_counter_name

Line 1268: FROM cs_counter_groups cgrp, cs_counters ctr

1264: -- Get counters that match on a given counter name.
1265: CURSOR cs_counters_name_csr(c_csi_item_instance_id NUMBER, c_name VARCHAR2) IS
1266: /*
1267: SELECT ctr.name counter_name, ctr.counter_id, ctr.uom_code, cgrp.counter_group_id
1268: FROM cs_counter_groups cgrp, cs_counters ctr
1269: WHERE cgrp.counter_group_id = ctr.counter_group_id
1270: AND cgrp.source_object_code = 'CP'
1271: AND cgrp.source_object_id = c_csi_item_instance_id
1272: AND ctr.name = c_name

Line 1438: Cannot use cs_counters and cs_counter_groups anymore **/

1434: i NUMBER;
1435: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_Reading_All';
1436:
1437: /** Begin changes by jaramana on October 29, 2007 for bug 6513576
1438: Cannot use cs_counters and cs_counter_groups anymore **/
1439: --Given start instance_id and uom_code, this cursor is used to get all of the distinct
1440: --counters this start instance has
1441: CURSOR get_inst_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1442: /*

Line 1445: cs_counter_groups CG

1441: CURSOR get_inst_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1442: /*
1443: SELECT DISTINCT CC.NAME counter_name
1444: FROM cs_counters CC,
1445: cs_counter_groups CG
1446: WHERE CC.counter_group_id = CG.counter_group_id
1447: AND CG.source_object_code = 'CP'
1448: AND CG.source_object_id = c_instance_id
1449: AND CC.uom_code = c_uom_code