[Home] [Help]
View: 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
Name |
CALENDAR_ENTRY_ID |
BUSINESS_GROUP_ID |
EVENT_NAME |
START_DATE |
END_DATE |
ORGANIZATION_ID |
ORGANIZATION_NAME |
ASSIGNMENT_ID |
PERSON_ID |