APPS.PQP_PERASGADD_RIW dependencies on PER_JOBS

Line 151: ,job_name per_jobs.name%type

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
155: ,pay_basis_name per_pay_bases.name%type

Line 389: from per_jobs pjb

385: cursor csr_job(c_job_id in number
386: ,c_business_group_id in number
387: ,c_effective_date in date) is
388: select jtl.name
389: from per_jobs pjb
390: ,per_jobs_tl jtl
391: where pjb.job_id = c_job_id
392: and jtl.job_id = pjb.job_id
393: and jtl.language = Userenv('LANG')

Line 390: ,per_jobs_tl jtl

386: ,c_business_group_id in number
387: ,c_effective_date in date) is
388: select jtl.name
389: from per_jobs pjb
390: ,per_jobs_tl jtl
391: where pjb.job_id = c_job_id
392: and jtl.job_id = pjb.job_id
393: and jtl.language = Userenv('LANG')
394: and pjb.business_group_id = c_business_group_id

Line 1915: l_job_name per_jobs.name%type;

1911: l_pay_basis_name per_pay_bases.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);

Line 7878: l_job_name per_jobs.name%type;

7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.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;