DBA Data[Home] [Help]

APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 976: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA

972: C.COUNTER_ID counter_id,
973: C.START_DATE_ACTIVE start_date_active,
974: C.END_DATE_ACTIVE end_date_active,
975: C.UOM_CODE uom_code
976: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
977: WHERE C.COUNTER_ID = CCA.COUNTER_ID(+)
978: AND CCA.SOURCE_OBJECT_CODE = 'CP'
979: AND CCA.SOURCE_OBJECT_ID = c_instance_id
980: AND C.COUNTER_TEMPLATE_NAME = c_counter_name

Line 1231: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA

1227: AND CCCV.COUNTER_TEMPLATE_NAME = c_counter_name
1228: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1229: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate))
1230: */
1231: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1232: WHERE CCA.SOURCE_OBJECT_ID = CI.subject_id
1233: AND C.COUNTER_ID = CCA.COUNTER_ID(+)
1234: AND CCA.SOURCE_OBJECT_CODE = 'CP'
1235: AND C.COUNTER_TEMPLATE_NAME = c_counter_name

Line 1466: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA

1462: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1463: -- Removed the use of csi_cp_counters_v
1464: CURSOR get_all_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1465: SELECT DISTINCT C.COUNTER_TEMPLATE_NAME counter_name
1466: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1467: WHERE C.UOM_CODE = c_uom_code
1468: AND trunc(nvl(C.start_date_active, sysdate)) <= trunc(sysdate)
1469: AND trunc(nvl(C.end_date_active, sysdate+1)) > trunc(sysdate)
1470: AND C.COUNTER_ID = CCA.COUNTER_ID(+)