[Home] [Help]
457: ,p_effective_date IN DATE
458: ) IS
459: SELECT pgd.ROWID
460: FROM per_grades pgr
461: ,per_grade_definitions pgd
462: ,per_all_assignments_f asg
463: WHERE pgr.grade_id = asg.grade_id
464: AND pgr.grade_definition_id = pgd.grade_definition_id
465: AND asg.assignment_id = p_assignment_id