APPS.QA_PLAN_ELEMENT_API dependencies on CSI_COUNTERS_VL

Line 1634: -- replacing cs_counters with csi_counters_vl

1630:
1631: id NUMBER;
1632: -- Bug 4958763. SQL Repository Fix SQL ID: 15008597
1633: -- to maintain consistency using IB view for counters
1634: -- replacing cs_counters with csi_counters_vl
1635: CURSOR c (c_name VARCHAR2) IS
1636: SELECT cc.counter_id
1637: FROM csi_counters_vl cc
1638: WHERE cc.name = c_name;

Line 1637: FROM csi_counters_vl cc

1633: -- to maintain consistency using IB view for counters
1634: -- replacing cs_counters with csi_counters_vl
1635: CURSOR c (c_name VARCHAR2) IS
1636: SELECT cc.counter_id
1637: FROM csi_counters_vl cc
1638: WHERE cc.name = c_name;
1639: /*
1640: SELECT cc.counter_id
1641: FROM cs_counters cc, cs_counter_groups ccg

Line 3905: FROM csi_counters_vl

3901: AND cc.name like :1
3902: ORDER BY 1';
3903: */
3904: sql_string := 'SELECT name, description
3905: FROM csi_counters_vl
3906: WHERE name like :1
3907: AND trunc(sysdate) BETWEEN nvl(start_date_active, trunc(sysdate))
3908: AND nvl(end_date_active, trunc(sysdate))
3909: ORDER BY 1';