APPS.PER_QH_POPULATE dependencies on PER_GRADES

Line 257: l_grade_name per_grades.name%type;

253: function get_grade
254: (p_grade_id number) return varchar2 is
255: --
256: l_proc varchar2(72) :=g_package||'get_grade';
257: l_grade_name per_grades.name%type;
258: --
259: cursor csr_grade is
260: select name
261: from per_grades_vl

Line 261: from per_grades_vl

257: l_grade_name per_grades.name%type;
258: --
259: cursor csr_grade is
260: select name
261: from per_grades_vl
262: where grade_id=p_grade_id;
263: begin
264: --
265: hr_utility.set_location('Entering: '||l_proc,10);

Line 419: ,p_grade OUT NOCOPY per_grades.name%type

415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
422: ) is
423: --

Line 835: ,p_grade OUT NOCOPY per_grades.name%type

831: ,p_effective_date IN date
832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type