APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_PROPERTIES_B

Line 244: CSI_COUNTER_PROPERTIES_B ccp

240: Begin
241: select 'x'
242: into l_exists
243: from CSI_COUNTER_READINGS ccr,
244: CSI_COUNTER_PROPERTIES_B ccp
245: where ccr.counter_value_id = p_ctr_value_id
246: and ccp.counter_id = ccr.counter_id
247: and ccp.counter_property_id = p_ctr_prop_id
248: and nvl(ccp.end_date_active,(sysdate+1)) > sysdate;

Line 3055: FROM CSI_COUNTER_DERIVED_FILTERS filt, CSI_COUNTER_PROPERTIES_B pro

3051: SELECT filt.counter_property_id, filt.seq_no,filt.left_parent left_paren,
3052: filt.right_parent right_paren, filt.relational_operator,
3053: filt.logical_operator, filt.right_value,
3054: pro.property_data_type
3055: FROM CSI_COUNTER_DERIVED_FILTERS filt, CSI_COUNTER_PROPERTIES_B pro
3056: WHERE filt.counter_id = b_counter_id
3057: AND pro.counter_property_id(+) = filt.counter_property_id;
3058: --
3059: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS

Line 5240: from CSI_COUNTER_PROPERTIES_B

5236: CURSOR PROP_LOV_CUR(p_prop_id IN NUMBER) IS
5237: select lookup_code,meaning --Meaning added for bug #6904836
5238: from CSI_LOOKUPS
5239: where lookup_type = (select property_lov_type
5240: from CSI_COUNTER_PROPERTIES_B
5241: where counter_property_id = p_prop_id);
5242: BEGIN
5243: -- Standard Start of API savepoint
5244: SAVEPOINT capture_ctr_property_reading;

Line 5287: from CSI_COUNTER_PROPERTIES_B

5283: --
5284: Begin
5285: select property_lov_type,property_data_type,is_nullable
5286: into l_prop_lov_type,l_property_type, l_is_nullable
5287: from CSI_COUNTER_PROPERTIES_B
5288: where counter_property_id = p_ctr_prop_rdg_rec.counter_property_id
5289: and nvl(end_date_active,(sysdate+1)) > sysdate;
5290: Exception
5291: when no_data_found then