APPS.PAY_FR_UPDATE_PCS_CODE dependencies on PER_JOBS

Line 13: from per_jobs pj

9: cursor csr_get_job (c_business_group_id number) is
10: select pj.job_id job_id
11: ,pj.name job_name
12: ,pj.job_information1 pcs_code
13: from per_jobs pj
14: where business_group_id = c_business_group_id
15: and JOB_INFORMATION_CATEGORY = 'FR'
16: and not exists (select 1
17: from fnd_common_lookups fcl

Line 45: update per_jobs

41: l_value := pay_fr_general.get_payroll_message('PAY_75193_OLD_CODE', null, null, null);
42: fnd_file.put_line(fnd_file.log, get_pcs_code.job_name||', old pcs code '|| get_pcs_code.pcs_code||l_value||' '||get_pcs_code.job_id);
43: /* Making the old pcs code to be null. The user will take the jobs from the log message and change the
44: old pcs codes to new pcs codes manually */
45: update per_jobs
46: set job_information1 = NULL
47: where business_group_id = p_business_group_id
48: and JOB_INFORMATION_CATEGORY = 'FR'
49: and job_id = get_pcs_code.job_id;

Line 51: update per_jobs

47: where business_group_id = p_business_group_id
48: and JOB_INFORMATION_CATEGORY = 'FR'
49: and job_id = get_pcs_code.job_id;
50: ELSE
51: update per_jobs
52: set job_information1 = l_new_code
53: where business_group_id = p_business_group_id
54: and JOB_INFORMATION_CATEGORY = 'FR'
55: and job_id = get_pcs_code.job_id;