APPS.PQP_PERASGADD_RIW dependencies on PER_GRADES

Line 148: (grade_name per_grades.name%type

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

Line 358: from per_grades pgr

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

Line 359: ,per_grades_tl gtl

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

Line 1815: l_grade_name per_grades.name%type;

1811: l_location_code hr_locations_all.location_code%type;
1812: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1813: l_job_name per_jobs.name%type;
1814: l_position_name hr_all_positions_f.name%type;
1815: l_grade_name per_grades.name%type;
1816: begin
1817: hr_utility.set_location('Entering: ' || l_proc_name, 5);
1818: g_wstr_names := null;
1819: -- Get grade name

Line 7476: l_grade_name per_grades.name%type;

7472: l_location_code hr_locations_all.location_code%type;
7473: l_payroll_name pay_payrolls_f.payroll_name%type;
7474: l_job_name per_jobs.name%type;
7475: l_position_name per_positions.name%type;
7476: l_grade_name per_grades.name%type;
7477:
7478: l_pradd_ovlapval_override boolean;
7479:
7480: begin