APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_PROPERTIES_B

Line 245: CSI_COUNTER_PROPERTIES_B ccp

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

Line 3571: FROM CSI_COUNTER_DERIVED_FILTERS filt, CSI_COUNTER_PROPERTIES_B pro

3567: SELECT filt.counter_property_id, filt.seq_no,filt.left_parent left_paren,
3568: filt.right_parent right_paren, filt.relational_operator,
3569: filt.logical_operator, filt.right_value,
3570: pro.property_data_type
3571: FROM CSI_COUNTER_DERIVED_FILTERS filt, CSI_COUNTER_PROPERTIES_B pro
3572: WHERE filt.counter_id = b_counter_id
3573: AND pro.counter_property_id(+) = filt.counter_property_id;
3574: --
3575: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS

Line 6084: from CSI_COUNTER_PROPERTIES_B

6080: CURSOR PROP_LOV_CUR(p_prop_id IN NUMBER) IS
6081: select lookup_code,meaning --Meaning added for bug #6904836
6082: from CSI_LOOKUPS
6083: where lookup_type = (select property_lov_type
6084: from CSI_COUNTER_PROPERTIES_B
6085: where counter_property_id = p_prop_id);
6086: BEGIN
6087: -- Standard Start of API savepoint
6088: SAVEPOINT capture_ctr_property_reading;

Line 6137: from CSI_COUNTER_PROPERTIES_B

6133: --
6134: Begin
6135: select property_lov_type,property_data_type,is_nullable
6136: into l_prop_lov_type,l_property_type, l_is_nullable
6137: from CSI_COUNTER_PROPERTIES_B
6138: where counter_property_id = p_ctr_prop_rdg_rec.counter_property_id
6139: and nvl(end_date_active,(sysdate+1)) > sysdate;
6140: Exception
6141: when no_data_found THEN