APPS.QA_PLAN_ELEMENT_API dependencies on CSI_COUNTERS_VL

Line 1653: -- replacing cs_counters with csi_counters_vl

1649:
1650: id NUMBER;
1651: -- Bug 4958763. SQL Repository Fix SQL ID: 15008597
1652: -- to maintain consistency using IB view for counters
1653: -- replacing cs_counters with csi_counters_vl
1654: CURSOR c (c_name VARCHAR2) IS
1655: SELECT cc.counter_id
1656: FROM csi_counters_vl cc
1657: WHERE cc.name = c_name;

Line 1656: FROM csi_counters_vl cc

1652: -- to maintain consistency using IB view for counters
1653: -- replacing cs_counters with csi_counters_vl
1654: CURSOR c (c_name VARCHAR2) IS
1655: SELECT cc.counter_id
1656: FROM csi_counters_vl cc
1657: WHERE cc.name = c_name;
1658: /*
1659: SELECT cc.counter_id
1660: FROM cs_counters cc, cs_counter_groups ccg

Line 4103: FROM csi_counters_vl

4099: AND cc.name like :1
4100: ORDER BY 1';
4101: */
4102: sql_string := 'SELECT name, description
4103: FROM csi_counters_vl
4104: WHERE name like :1
4105: AND trunc(sysdate) BETWEEN nvl(start_date_active, trunc(sysdate))
4106: AND nvl(end_date_active, trunc(sysdate))
4107: ORDER BY 1';