SELECT ASG.JOB_POST_SOURCE_NAME ID , ASG.JOB_POST_SOURCE_NAME VALUE , ASG.EFFECTIVE_START_DATE START_DATE , ASG.EFFECTIVE_END_DATE END_DATE , ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F ASG WHERE ASG.JOB_POST_SOURCE_NAME IS NOT NULL UNION ALL SELECT 'NA_EDW' ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE , -1 BUSINESS_GROUP_ID FROM DUAL WITH READ ONLY