DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,

1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,
1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1181: WHERE acc.incident_id=b_inc_id
1182: AND au.USER_ID=acc.USER_ID
1183: AND INC.incident_id=acc.incident_id