APPS.CSI_COUNTER_READINGS_PUB dependencies on CSI_CTR_PROPERTY_READINGS

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

51: where ccp.counter_id = p_counter_id
52: and ((ccp.default_value is not null) or
53: (ccp.default_value is null and ccp.is_nullable = 'N'))
54: and nvl(end_date_active,(sysdate+1)) > sysdate
55: and not exists (select 'x' from CSI_CTR_PROPERTY_READINGS cpr
56: Where cpr.counter_value_id = p_value_id
57: and cpr.counter_property_id = ccp.counter_property_id);
58: --
59: CURSOR LATER_READINGS_CUR(p_counter_id IN NUMBER,p_value_timestamp IN DATE) IS