APPS.PER_VGR_BUS dependencies on PER_JOBS_V

Line 110: -- per_jobs_v for the job_id if it is not null.

106: -- Validates that date from is equal to or later than the effective_date of
107: -- hr_positions_f for the position_id if it is not null.
108: --
109: -- Validates that date from is equal to or later than the date_from of
110: -- per_jobs_v for the job_id if it is not null.
111: --
112: -- Pre-conditions:
113: -- Format of p_date_from and p_date_to must be correct
114: --

Line 160: from per_jobs_v job

156: and nvl(gra.date_to, hr_api.g_eot);
157: --
158: cursor csr_chk_job_dates is
159: select null
160: from per_jobs_v job
161: where job.job_id = p_job_id
162: and p_date_from >= job.date_from;
163: --
164: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.

Line 225: -- Check that date_from is on or later than the date_from on per_jobs_v for

221: end if;
222: close csr_chk_gra_dates;
223: hr_utility.set_location(l_proc, 4);
224: --
225: -- Check that date_from is on or later than the date_from on per_jobs_v for
226: -- p_job_id
227: --
228: if p_job_id is not null then
229: open csr_chk_job_dates;

Line 315: -- Validates that a job id exists in the view per_jobs_v

311: -- |---------------------------< chk_job_id >----------------------------|
312: -- ----------------------------------------------------------------------------
313: --
314: -- Description :
315: -- Validates that a job id exists in the view per_jobs_v
316: --
317: -- Validates that the business group id for the job is the same as that
318: -- for the valid grade.
319: --

Line 330: -- If a row does exist in per_jobs_v for the given job id then

326: -- In Arguments :
327: -- p_job_id
328: --
329: -- Post Success :
330: -- If a row does exist in per_jobs_v for the given job id then
331: -- processing continues
332: --
333: -- Post Failure :
334: -- if a row does not exist in per_jobs_v for the given job_id then

Line 334: -- if a row does not exist in per_jobs_v for the given job_id then

330: -- If a row does exist in per_jobs_v for the given job id then
331: -- processing continues
332: --
333: -- Post Failure :
334: -- if a row does not exist in per_jobs_v for the given job_id then
335: -- an application error will be raised and processing is terminated
336: --
337: -- Access Status :
338: -- Internal Table Handler Use only.

Line 355: from per_jobs_v job

351: l_business_group_id number(15);
352: --
353: cursor csr_valid_job is
354: select job.business_group_id
355: from per_jobs_v job
356: where job.job_id = p_job_id;
357: --
358: cursor csr_chk_job_grd_comb is
359: select null

Line 380: -- per_jobs_v

376: hr_utility.set_location('Entering: '|| l_proc, 1);
377: --
378: --
379: -- Check that the job ID, if it is not null, is linked to a valid job on
380: -- per_jobs_v
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc,
384: p_argument => 'grade_id',

Line 560: -- per_jobs_v for the job_id if it is not null.

556: -- Validates that date to is equal to or earlier than the effective_date of
557: -- hr_positions_f for the position_id if it is not null.
558: --
559: -- Validates that date to is equal to or earlier than the date_to of
560: -- per_jobs_v for the job_id if it is not null.
561: --
562: -- Pre-conditions:
563: -- Format of p_date_from and p_date_to must be correct
564: --

Line 609: from per_jobs_v job

605: and nvl(gra.date_to, hr_api.g_eot);
606: --
607: cursor csr_chk_job_dates is
608: select null
609: from per_jobs_v job
610: where job.job_id = p_job_id
611: and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);
612: --
613: -- Changes 12-Oct-99 SCNair (per_postions to hr_positions) date tracked position req.

Line 676: -- Check that date_to is on or earlier than the date_to on per_jobs_v for

672: end if;
673: close csr_chk_gra_dates;
674: hr_utility.set_location(l_proc, 4);
675: --
676: -- Check that date_to is on or earlier than the date_to on per_jobs_v for
677: -- p_job_id
678: --
679: if p_job_id is not null then
680: open csr_chk_job_dates;