APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 601: FROM CS_HZ_SR_CONTACT_POINTS

597: c_incident_id number
598: )
599: IS
600: SELECT contact_type, party_id
601: FROM CS_HZ_SR_CONTACT_POINTS
602: WHERE incident_id = c_incident_id
603: AND primary_flag = 'Y';
604:
605: l_contact_rec get_contact_details%rowtype;