View: HR_CERIDIAN_500_SPOUSE_V

Product:	PER - Human Resources
Description:	Ceridian Source 500 payroll interface view
Implementation/DBA Data:	APPS.HR_CERIDIAN_500_SPOUSE_V

View Text

SELECT C.BUSINESS_GROUP_ID
, C.PERSON_ID
, C.CONTACT_PERSON_ID
, SP.FULL_NAME
, SP.EMPLOYEE_NUMBER
, SP.DATE_OF_BIRTH
FROM PER_ALL_PEOPLE_F SP
, PER_CONTACT_RELATIONSHIPS C
WHERE SP.PERSON_ID = C.CONTACT_PERSON_ID
AND C.CONTACT_TYPE = 'S'
AND TRUNC (HR_CERIDIAN.GET_CER_EXTRACT_DATE) BETWEEN SP.EFFECTIVE_START_DATE
AND SP.EFFECTIVE_END_DATE
AND TRUNC(HR_CERIDIAN.GET_CER_EXTRACT_DATE) BETWEEN C.DATE_START
AND NVL(C.DATE_END
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))

Columns