DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSI_CTR_PROPERTY_READINGS

Line 293: FROM csi_ctr_property_readings ccpr

289: CURSOR l_counter_prop_value_ins_csr
290: IS
291: SELECT ccpr.counter_prop_value_id
292: , ccva.user_id
293: FROM csi_ctr_property_readings ccpr
294: , csm_counter_values_acc ccva
295: WHERE ccpr.counter_value_id = ccva.counter_value_id
296: AND ccva.user_id IN ( SELECT cpa.user_id
297: FROM csm_party_assignment cpa

Line 506: FROM csi_ctr_property_readings ccpr

502: CURSOR l_counter_prop_value_del_csr
503: IS
504: SELECT ccpr.counter_prop_value_id
505: , ccpva.user_id
506: FROM csi_ctr_property_readings ccpr
507: , csm_counter_prop_values_acc ccpva
508: WHERE ccpva.counter_prop_value_id = ccpr.counter_prop_value_id
509: AND NOT EXISTS (SELECT 1
510: FROM csm_counter_values_acc ccva