View: PER_CAL_EVENT_ELIGIBILITY_V

Product:	PER - Human Resources
Description:	Calendar Event Eligibility
Implementation/DBA Data:	APPS.PER_CAL_EVENT_ELIGIBILITY_V

View Text

SELECT ENT.CALENDAR_ENTRY_ID
, ENT.BUSINESS_GROUP_ID
, ENT.NAME
, ENT.START_DATE
, ENT.END_DATE
, LIS.ORGANIZATION_ID
, HOU.NAME
, ASG.ASSIGNMENT_ID
, ASG.PERSON_ID
FROM PER_CAL_ENTRY_ORG_LIST LIS
, PER_CALENDAR_ENTRIES ENT
, HR_ALL_ORGANIZATION_UNITS HOU
, PER_ALL_ASSIGNMENTS_F ASG
WHERE LIS.CALENDAR_ENTRY_ID = ENT.CALENDAR_ENTRY_ID
AND LIS.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND ASG.ORGANIZATION_ID = LIS.ORGANIZATION_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND ASG.ASSIGNMENT_TYPE IN ('E')
AND ENT.START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE

Columns