APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_PARTY_ASSIGNMENT
Line 699: FROM csm_party_assignment cpa
695: AND ciab.incident_id = jtb.source_object_id
696: AND jtb.source_object_type_code = 'SR'
697: and jtb.scheduled_start_date > (sysdate - NVL(fnd_profile.value_specific('CSF_M_HISTORY'),100))
698: AND ciia.user_id IN ( SELECT cpa.user_id 699: FROM csm_party_assignment cpa 700: WHERE cpa.deleted_flag ='N'
701: )
702: AND NOT EXISTS ( SELECT 1
703: FROM csm_service_history_acc csha