APPS.PQH_DE_LOCAL_COST_LIVING_PKG dependencies on PER_GRADES

Line 90: select grade_id from per_grades

86:
87: -- cursor to get the grade_id of the required Pay grade of the Employee
88:
89: Cursor c_grade_id (p_pay_grade varchar2 ,p_business_group_id number,p_effective_date date) is
90: select grade_id from per_grades
91: where name = p_pay_grade
92: and business_group_id = p_business_group_id
93: and p_effective_date between DATE_from and nvl(DATE_to,p_effective_date ) ;
94: