*************************************
Employee Basic Information
************************************
select distinct pp.PERSON_ID,
PPNF.FIRST_NAME,
PPNF.LAST_NAME,
to_char(PP.START_DATE,'dd-mon-yyyy') start_date,
to_char(PP.DATE_OF_BIRTH, 'dd-mon-yyyy') dob,
pea.email_address
from PER_PERSONS PP,
PER_PERSON_NAMES_F PPNF,
PER_EMAIL_ADDRESSES PEA
where
PP.PERSON_ID = PPNF.PERSON_ID
and PP.PERSON_ID = PEA.PERSON_ID
and PPNF.NAME_TYPE = 'GLOBAL'
and pea.email_address in ('test@test.com')