SELECT DISTINCT asg.job_post_source_name ID ,asg.job_post_source_name VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,-1 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
SELECT DISTINCT ASG.JOB_POST_SOURCE_NAME ID
, ASG.JOB_POST_SOURCE_NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 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
|
|
|