DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSI_COUNTER_PROPERTIES_B

Line 314: FROM csi_counter_properties_b ccpb

310: CURSOR l_counter_property_ins_csr
311: IS
312: SELECT ccpb.counter_property_id
313: , cca.user_id
314: FROM csi_counter_properties_b ccpb
315: , csm_counters_acc cca
316: WHERE ccpb.counter_id = cca.counter_id
317: AND cca.user_id IN ( SELECT cpa.user_id
318: FROM csm_party_assignment cpa

Line 522: FROM csi_counter_properties_b ccpb

518: CURSOR l_counter_property_del_csr
519: IS
520: SELECT ccpb.counter_property_id
521: , ccpa.user_id
522: FROM csi_counter_properties_b ccpb
523: , csm_counter_properties_acc ccpa
524: WHERE ccpa.counter_property_id = ccpb.counter_property_id
525: AND NOT EXISTS(SELECT 1
526: FROM csm_counters_acc cca