DBA Data[Home] [Help]

APPS.CSI_CTR_INTERFACE_PUB dependencies on CSI_CTR_PROPERTY_READINGS

Line 212: and not exists (select 'x' from CSI_CTR_PROPERTY_READINGS cpr

208: where ccp.counter_id = p_counter_id
209: and ((ccp.default_value is not null) or
210: (ccp.default_value is null and ccp.is_nullable = 'N'))
211: and nvl(end_date_active,(sysdate+1)) > sysdate
212: and not exists (select 'x' from CSI_CTR_PROPERTY_READINGS cpr
213: Where cpr.counter_value_id = p_value_id
214: and cpr.counter_property_id = ccp.counter_property_id);
215: --
216: CURSOR LATER_READINGS_CUR(p_counter_id IN NUMBER,p_value_timestamp IN DATE) IS