APPS.PQP_HROSS_INTEGRATION dependencies on PER_JOBS

Line 323: FROM per_jobs pjb

319: CURSOR csr_job(c_job_id IN Number
320: ,c_business_group_id IN Number
321: ,c_effective_date IN Date) IS
322: SELECT jtl.NAME
323: FROM per_jobs pjb
324: ,per_jobs_tl jtl
325: WHERE pjb.job_id = c_job_id
326: AND jtl.job_id = pjb.job_id
327: AND jtl.LANGUAGE = Userenv('LANG')

Line 324: ,per_jobs_tl jtl

320: ,c_business_group_id IN Number
321: ,c_effective_date IN Date) IS
322: SELECT jtl.NAME
323: FROM per_jobs pjb
324: ,per_jobs_tl jtl
325: WHERE pjb.job_id = c_job_id
326: AND jtl.job_id = pjb.job_id
327: AND jtl.LANGUAGE = Userenv('LANG')
328: AND pjb.business_group_id = c_business_group_id

Line 2743: l_job_name per_jobs.NAME%TYPE;

2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;
2744: l_position_name per_positions.NAME%TYPE;
2745: l_grade_name per_grades.NAME%TYPE;
2746: l_user_person_type per_person_types.user_person_type%TYPE;
2747: l_user_sequence Number := 1;

Line 3935: l_job_name per_jobs.NAME%TYPE;

3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
3935: l_job_name per_jobs.NAME%TYPE;
3936: l_position_name per_positions.NAME%TYPE;
3937: l_grade_name per_grades.NAME%TYPE;
3938:
3939: l_pradd_ovlapval_override Boolean;