38: -- {End Of Comments}
39: -- ----------------------------------------------------------------------------
40: procedure chk_previous_job_id
41: (p_previous_job_id
42: in per_previous_jobs.previous_job_id%type
43: ,p_previous_job_extra_info_id
44: in per_prev_job_extra_info.previous_job_extra_info_id%type
45: ,p_object_version_number
46: in per_prev_job_extra_info.object_version_number%type) is
45: ,p_object_version_number
46: in per_prev_job_extra_info.object_version_number%type) is
47: cursor csr_previous_job_id is
48: select previous_job_id
49: from per_previous_jobs
50: where previous_job_id = p_previous_job_id;
51: l_previous_job_id per_previous_jobs.previous_job_id%type;
52: --
53: l_proc varchar2(72) := g_package||'chk_previous_job_id';
47: cursor csr_previous_job_id is
48: select previous_job_id
49: from per_previous_jobs
50: where previous_job_id = p_previous_job_id;
51: l_previous_job_id per_previous_jobs.previous_job_id%type;
52: --
53: l_proc varchar2(72) := g_package||'chk_previous_job_id';
54: l_api_updating boolean;
55: begin
177: cursor csr_sec_grp is
178: select pbg.security_group_id
179: from per_business_groups pbg
180: , per_prev_job_extra_info pji
181: , per_previous_jobs pjo
182: , per_previous_employers pem
183: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
184: and pji.previous_job_id = pjo.previous_job_id
185: and pjo.previous_employer_id = pem.previous_employer_id
240: cursor csr_leg_code is
241: select pbg.legislation_code
242: from per_business_groups pbg
243: , per_prev_job_extra_info pji
244: , per_previous_jobs pjo
245: , per_previous_employers pem
246: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
247: and pji.previous_job_id = pjo.previous_job_id
248: and pjo.previous_employer_id = pem.previous_employer_id(+)