APPS.PER_QH_POPULATE dependencies on PER_GRADES

Line 250: l_grade_name per_grades.name%type;

246: function get_grade
247: (p_grade_id number) return varchar2 is
248: --
249: l_proc varchar2(72) :=g_package||'get_grade';
250: l_grade_name per_grades.name%type;
251: --
252: cursor csr_grade is
253: select name
254: from per_grades_vl

Line 254: from per_grades_vl

250: l_grade_name per_grades.name%type;
251: --
252: cursor csr_grade is
253: select name
254: from per_grades_vl
255: where grade_id=p_grade_id;
256: begin
257: --
258: hr_utility.set_location('Entering: '||l_proc,10);

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

408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
412: ,p_grade OUT NOCOPY per_grades.name%type
413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
414: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
415: ) is
416: --

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

824: ,p_effective_date IN date
825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type