APPS.PQP_PERASGADD_RIW dependencies on HR_ALL_POSITIONS_F

Line 150: ,position_name hr_all_positions_f.name%type

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

Line 374: from hr_all_positions_f pos

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

Line 375: ,hr_all_positions_f_tl ptl

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

Line 1916: l_position_name hr_all_positions_f.name%type;

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