APPS.PQP_PERASGADD_RIW dependencies on PER_GRADES

Line 149: (grade_name per_grades.name%type

145: ,orig_hire_warning boolean
146: );
147:
148: type t_asg_wrk_strs is record
149: (grade_name per_grades.name%type
150: ,position_name hr_all_positions_f.name%type
151: ,job_name per_jobs.name%type
152: ,payroll_name pay_all_payrolls_f.payroll_name%type
153: ,organization_name hr_all_organization_units.name%type

Line 359: from per_grades pgr

355: cursor csr_grade(c_grade_id in number
356: ,c_business_group_id in number
357: ,c_effective_date in date) is
358: select gtl.name
359: from per_grades pgr
360: ,per_grades_tl gtl
361: where pgr.grade_id = c_grade_id
362: and gtl.grade_id = pgr.grade_id
363: and gtl.language = userenv('LANG')

Line 360: ,per_grades_tl gtl

356: ,c_business_group_id in number
357: ,c_effective_date in date) is
358: select gtl.name
359: from per_grades pgr
360: ,per_grades_tl gtl
361: where pgr.grade_id = c_grade_id
362: and gtl.grade_id = pgr.grade_id
363: and gtl.language = userenv('LANG')
364: and pgr.business_group_id = c_business_group_id

Line 1917: l_grade_name per_grades.name%type;

1913: l_location_code hr_locations_all.location_code%type;
1914: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1915: l_job_name per_jobs.name%type;
1916: l_position_name hr_all_positions_f.name%type;
1917: l_grade_name per_grades.name%type;
1918: begin
1919: hr_utility.set_location('Entering: ' || l_proc_name, 5);
1920: g_wstr_names := null;
1921: -- Get grade name

Line 7880: l_grade_name per_grades.name%type;

7876: l_location_code hr_locations_all.location_code%type;
7877: l_payroll_name pay_payrolls_f.payroll_name%type;
7878: l_job_name per_jobs.name%type;
7879: l_position_name per_positions.name%type;
7880: l_grade_name per_grades.name%type;
7881:
7882: l_pradd_ovlapval_override boolean;
7883:
7884: begin