APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 658: FROM CS_HZ_SR_CONTACT_POINTS

654: c_incident_id number
655: )
656: IS
657: SELECT contact_type, party_id
658: FROM CS_HZ_SR_CONTACT_POINTS
659: WHERE incident_id = c_incident_id
660: AND primary_flag = 'Y';
661:
662: l_contact_rec get_contact_details%rowtype;