Monday, April 14, 2025

How do you Delete Loaded Assignment Grade Steps Data ?

 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'
  

No comments:

Post a Comment