VIEW: APPS.PER_CAL_EVENT_ELIGIBILITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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