APPS.PE_JEI_BUS dependencies on PER_JOBS

Line 36: , per_jobs pj

32: cursor csr_leg_code is
33: select pbg.legislation_code
34: from per_business_groups pbg
35: , per_job_extra_info jei
36: , per_jobs pj
37: where jei.job_extra_info_id = p_job_extra_info_id
38: and jei.job_id = pj.job_id
39: and pbg.business_group_id = pj.business_group_id;
40: --

Line 184: -- Verify that the value in job_ID is in the per_jobs Table.-- Bug No.2173007

180: -- ----------------------------------------------------------------------------
181: -- {Start Of Comments}
182: --
183: -- Description:
184: -- Verify that the value in job_ID is in the per_jobs Table.-- Bug No.2173007
185: --
186: -- Pre Conditions:
187: --
188: --

Line 219: -- can be used to look for validity of job_id. So per_jobs_v is changed

215: l_dummy varchar2(1);
216: --
217:
218: -- Bug 2173007 Starts Here. View is only for default job groups, Base table
219: -- can be used to look for validity of job_id. So per_jobs_v is changed
220: -- to per_jobs.
221:
222: cursor c_valid_job (id number) is
223: select 'x'

Line 220: -- to per_jobs.

216: --
217:
218: -- Bug 2173007 Starts Here. View is only for default job groups, Base table
219: -- can be used to look for validity of job_id. So per_jobs_v is changed
220: -- to per_jobs.
221:
222: cursor c_valid_job (id number) is
223: select 'x'
224: from per_jobs

Line 224: from per_jobs

220: -- to per_jobs.
221:
222: cursor c_valid_job (id number) is
223: select 'x'
224: from per_jobs
225: where job_id = id;
226:
227: -- Bug 2173007, End.
228:

Line 243: -- Check that the job_id is in the per_jobs table.

239: p_argument_value => p_job_id
240: );
241: hr_utility.set_location(l_proc, 2);
242: --
243: -- Check that the job_id is in the per_jobs table.
244: --
245: open c_valid_job (p_job_id);
246: fetch c_valid_job into l_dummy;
247: if c_valid_job%notfound then