APPS.PQP_PERASGADD_RIW dependencies on HR_ALL_POSITIONS_F

Line 149: ,position_name hr_all_positions_f.name%type

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
153: ,location_code hr_locations_all.location_code%type

Line 373: from hr_all_positions_f pos

369: cursor csr_position(c_position_id in number
370: ,c_business_group_id in number
371: ,c_effective_date in date) is
372: select ptl.name
373: from hr_all_positions_f pos
374: ,hr_all_positions_f_tl ptl
375: where pos.position_id = c_position_id
376: and ptl.position_id = pos.position_id
377: and ptl.language = userenv('LANG')

Line 374: ,hr_all_positions_f_tl ptl

370: ,c_business_group_id in number
371: ,c_effective_date in date) is
372: select ptl.name
373: from hr_all_positions_f pos
374: ,hr_all_positions_f_tl ptl
375: where pos.position_id = c_position_id
376: and ptl.position_id = pos.position_id
377: and ptl.language = userenv('LANG')
378: and pos.business_group_id = c_business_group_id

Line 1814: l_position_name hr_all_positions_f.name%type;

1810: l_organization_name hr_all_organization_units.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;