APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_CTR_PROPERTY_READINGS

Line 115: from CSI_CTR_PROPERTY_READINGS

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

Line 267: from CSI_CTR_PROPERTY_READINGS

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

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

3251: l_sqlfrom := ' CSI_COUNTER_READINGS cv1';
3252: l_sqlwhere := '';
3253: --
3254: FOR filts IN der_filters(ctrs.counter_id) LOOP
3255: l_sqlfrom := l_sqlfrom ||', CSI_CTR_PROPERTY_READINGS pv';
3256: l_sqlfrom := l_sqlfrom ||ltrim(rtrim(filts.seq_no));
3257: l_sqlwhere := l_sqlwhere || nvl(filts.left_paren,' ')||' pv';
3258: l_sqlwhere := l_sqlwhere || ltrim(rtrim(filts.seq_no));
3259: l_sqlwhere := l_sqlwhere || '.property_value ';

Line 5370: select CSI_CTR_PROPERTY_READINGS_S.nextval

5366: -- Generate Counter_Prop_Value_id
5367: IF p_ctr_prop_rdg_rec.counter_prop_value_id IS NULL OR
5368: p_ctr_prop_rdg_rec.counter_prop_value_id = FND_API.G_MISS_NUM THEN
5369: WHILE l_process_flag LOOP
5370: select CSI_CTR_PROPERTY_READINGS_S.nextval
5371: into p_ctr_prop_rdg_rec.counter_prop_value_id from dual;
5372: IF NOT Counter_Prop_Value_Exists(p_ctr_prop_rdg_rec.counter_prop_value_id) THEN
5373: l_process_flag := FALSE;
5374: END IF;