DBA Data[Home] [Help]

APPS.CSI_CTR_INTERFACE_PUB dependencies on CSI_CTR_PROPERTY_READINGS

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

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