APPS.PQH_CPD_BUS dependencies on PER_GRADES

Line 603: FROM per_grades

599: Procedure chk_starting_grade_id(p_starting_grade_id NUMBER,
600: p_effective_date DATE) IS
601: CURSOR csr_valid_grade IS
602: SELECT 'Y'
603: FROM per_grades
604: WHERE grade_id = p_starting_grade_id
605: AND p_effective_date BETWEEN date_from AND nvl(date_to,to_date('31/12/4712','DD/MM/RRRR'));
606: l_valid varchar2(1) := 'N';
607: l_proc varchar2(72);