SELECT 'METADATA|AssignmentGradeSteps|EffectiveStartDate|EffectiveEndDate|AssignGradeStepId|AssignmentNumber|GradeStepName' HEADER, 1 DATA_ORDER
FROM DUAL
UNION ALL
SELECT 'DELETE|AssignmentGradeSteps'
||'|'||
TO_CHAR(pagsf.EFFECTIVE_START_DATE,'YYYY/MM/DD')
||'|'||
TO_CHAR(pagsf.EFFECTIVE_END_DATE,'YYYY/MM/DD')
||'|'||
pagsf.ASSIGN_GRADE_STEP_ID
||'|'||
paam.assignment_number
||'|'||
pgsfv.name,
2 DATA_ORDER
FROM PER_ASSIGN_GRADE_STEPS_F pagsf,
PER_GRADE_STEPS_F_VL pgsfv,
PER_ALL_ASSIGNMENTS_M paam
WHERE pagsf.GRADE_STEP_ID = pgsfv.GRADE_STEP_ID
AND TRUNC(SYSDATE) BETWEEN pagsf.effective_start_date AND pagsf.effective_end_date
AND TRUNC(SYSDATE) BETWEEN pgsfv.effective_start_date AND pgsfv.effective_end_date
AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date
AND pagsf.assignment_id = paam.assignment_id
AND paam.assignment_type = 'E'
AND paam.effective_latest_change = 'Y'
FROM DUAL
UNION ALL
SELECT 'DELETE|AssignmentGradeSteps'
||'|'||
TO_CHAR(pagsf.EFFECTIVE_START_DATE,'YYYY/MM/DD')
||'|'||
TO_CHAR(pagsf.EFFECTIVE_END_DATE,'YYYY/MM/DD')
||'|'||
pagsf.ASSIGN_GRADE_STEP_ID
||'|'||
paam.assignment_number
||'|'||
pgsfv.name,
2 DATA_ORDER
FROM PER_ASSIGN_GRADE_STEPS_F pagsf,
PER_GRADE_STEPS_F_VL pgsfv,
PER_ALL_ASSIGNMENTS_M paam
WHERE pagsf.GRADE_STEP_ID = pgsfv.GRADE_STEP_ID
AND TRUNC(SYSDATE) BETWEEN pagsf.effective_start_date AND pagsf.effective_end_date
AND TRUNC(SYSDATE) BETWEEN pgsfv.effective_start_date AND pgsfv.effective_end_date
AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date
AND pagsf.assignment_id = paam.assignment_id
AND paam.assignment_type = 'E'
AND paam.effective_latest_change = 'Y'
No comments:
Post a Comment