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 1195: Cannot use cs_counters and cs_counter_groups anymore **/

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

Line 1204: cs_counter_groups CG

1200: FROM csi_ii_relationships CI
1201: WHERE EXISTS (SELECT 'X'
1202: /*
1203: FROM cs_counters CC,
1204: cs_counter_groups CG
1205: WHERE CC.counter_group_id = CG.counter_group_id
1206: AND CG.source_object_id = CI.subject_id
1207: AND CG.source_object_code = 'CP'
1208: AND CC.name = c_counter_name

Line 1256: FROM cs_counter_groups cgrp, cs_counters ctr

1252: -- Get counters that match on a given counter name.
1253: CURSOR cs_counters_name_csr(c_csi_item_instance_id NUMBER, c_name VARCHAR2) IS
1254: /*
1255: SELECT ctr.name counter_name, ctr.counter_id, ctr.uom_code, cgrp.counter_group_id
1256: FROM cs_counter_groups cgrp, cs_counters ctr
1257: WHERE cgrp.counter_group_id = ctr.counter_group_id
1258: AND cgrp.source_object_code = 'CP'
1259: AND cgrp.source_object_id = c_csi_item_instance_id
1260: AND ctr.name = c_name

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

1422: i NUMBER;
1423: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_Reading_All';
1424:
1425: /** Begin changes by jaramana on October 29, 2007 for bug 6513576
1426: Cannot use cs_counters and cs_counter_groups anymore **/
1427: --Given start instance_id and uom_code, this cursor is used to get all of the distinct
1428: --counters this start instance has
1429: CURSOR get_inst_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1430: SELECT DISTINCT CCCV.COUNTER_TEMPLATE_NAME counter_name