APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_CTR_PROPERTY_READINGS

Line 116: from CSI_CTR_PROPERTY_READINGS

112: BEGIN
113: Begin
114: select 'x'
115: into l_exists
116: from CSI_CTR_PROPERTY_READINGS
117: where counter_prop_value_id = p_ctr_prop_value_id;
118: l_return_value := TRUE;
119: Exception
120: when no_data_found then

Line 268: from CSI_CTR_PROPERTY_READINGS

264: l_s_temp varchar2(1);
265: BEGIN
266: select 'x'
267: into l_s_temp
268: from CSI_CTR_PROPERTY_READINGS
269: where counter_property_id = p_counter_property_id
270: and counter_value_id = p_counter_value_id;
271: return 'T';
272: EXCEPTION

Line 3782: l_sqlfrom := l_sqlfrom ||', CSI_CTR_PROPERTY_READINGS pv';

3778: l_sqlfrom := ' CSI_COUNTER_READINGS cv1';
3779: l_sqlwhere := '';
3780: --
3781: FOR filts IN der_filters(ctrs.counter_id) LOOP
3782: l_sqlfrom := l_sqlfrom ||', CSI_CTR_PROPERTY_READINGS pv';
3783: l_sqlfrom := l_sqlfrom ||ltrim(rtrim(filts.seq_no));
3784: l_sqlwhere := l_sqlwhere || nvl(filts.left_paren,' ')||' pv';
3785: l_sqlwhere := l_sqlwhere || ltrim(rtrim(filts.seq_no));
3786: l_sqlwhere := l_sqlwhere || '.property_value ';

Line 6224: select CSI_CTR_PROPERTY_READINGS_S.nextval

6220: -- Generate Counter_Prop_Value_id
6221: IF p_ctr_prop_rdg_rec.counter_prop_value_id IS NULL OR
6222: p_ctr_prop_rdg_rec.counter_prop_value_id = FND_API.G_MISS_NUM THEN
6223: WHILE l_process_flag LOOP
6224: select CSI_CTR_PROPERTY_READINGS_S.nextval
6225: into p_ctr_prop_rdg_rec.counter_prop_value_id from dual;
6226: IF NOT Counter_Prop_Value_Exists(p_ctr_prop_rdg_rec.counter_prop_value_id) THEN
6227: l_process_flag := FALSE;
6228: END IF;