PER_ALL_PEOPLE_F
HZ_PARTIES
PARTY_ID
from sequence HZ_PARTIES_S
PARTY_NUMBER
from sequence HZ_PARTY_NUMBER_S
PARTY_NAME
FIRST_NAME + " " + LAST_NAME
PARTY_TYPE
"PERSON"
VALIDATED_FLAG
"N"
LAST_UPDATED_BY
FND.USER_ID
CREATION_DATE
SYSDATE
CREATED_BY
FND.USER_ID
LAST_UPDATE_DATE SYSDATE
ORIG_SYSTEM_REFERENCE "PER:" + PERSON_ID
PERSON_ID
PERSON_IDENTIFIER
STATUS
"A" - Active
CREATED_BY_MODULE "HR
API"
PER_ALL_PEOPLE_F HZ_PERSON_PROFILES
PERSON_PROFILE_ID from sequence
HZ_PERSON_PROFILES_S
PARTY_ID
from HZ_PARTIES.PARTY_ID
FULL_NAME
PERSON_NAME
LAST_UPDATED_BY
FND.USER_ID
CREATION_DATE
SYSDATE
CREATED_BY
FND.USER_ID
LAST_UPDATE_DATE SYSDATE
SEX
GENDER
"MALE", "FEMALE" or "UNSPECIFIED"
MARITAL_STATUS
MARITAL_STATUS
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
CREATED_BY_MODULE "HR
API"
PER_ALL_PEOPLE_F HZ_CONTACT_POINTS
CONTACT_POINT_ID from
sequence HZ_CONTACT_POINTS_S
CONTACT_POINT_TYPE "EMAIL"
STATUS
stat
"A" - Active
OWNER_TABLE_NAME
"HZ_PARTIES"
OWNER_TABLE_ID
PARTY_ID
PRIMARY_FLAG
"Y"
ORIG_SYSTEM_REFERENCE CONTACT_POINT_ID
LAST_UPDATE_DATE SYSDATE
LAST_UPDATED_BY
FND.USER_ID
CREATION_DATE
SYSDATE
CREATED_BY
FND.USER_ID
EMAIL_ADDRESS
EMAIL_ADDRESS
CREATED_BY_MODULE "HR
API"
Select hz.party_id party,
hz.party_name name,
hz.person_identifier person_id
from hz_parties hz
where party_type = 'PERSON'
AND HZ.STATUS = 'A'
AND HZ.ORIG_SYSTEM_REFERENCE like 'PER%'
and hz.PERSON_IDENTIFIER is not null
and created_by_module = 'HR API'
and exists ( select 1 from per_all_people_f ppf
where ppf.person_id = hz.PERSON_IDENTIFIER
and ppf.party_id = hz.party_id)
