How to get the emergency contact name against employee

You can check on the Subject Area "Workforce Management - Person Real Time". The Contact details are under "Person Contact Relationships"
 
In case if want to get the details using BIP Report, then the details are available in PER_CONTACT_RELATIONSHIPS table.
 
Display Name: Workforce Management - Person Real Time -> Person Contact Relationship
 
Country: Workforce Management - Person Real Time -> Person Contact Relationship -> Contact Address
 
Contact Type: Workforce Management - Person Real Time -> Person Contact Relationship
 
Emergency Contact: Workforce Management - Person Real Time -> Person Contact Relationship
 
Address: Workforce Management - Person Real Time -> Person Contact Relationship -> Contact Address

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.