DBA Data[Home] [Help]

APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PER_GRADES_VL

Line 42: FROM PER_GRADES_VL GRA

38: AND pgr.effective_end_date;
39:
40: cursor grade_name IS
41: SELECT GRA.NAME
42: FROM PER_GRADES_VL GRA
43: , PER_ALL_ASSIGNMENTS_F ASG
44: WHERE ASG.ASSIGNMENT_ID=p_assignment_id
45: AND ASG.GRADE_ID=GRA.GRADE_ID
46: AND p_date BETWEEN asg.effective_start_date