APPS.PER_ASG_BUS1 dependencies on PER_JOBS

Line 5949: from per_jobs_v

5945: -- Description : Changed the cursor sql query to improve the performance
5946: --
5947: /* cursor csr_valid_job is
5948: select business_group_id
5949: from per_jobs_v
5950: where job_id = p_job_id
5951: and p_validation_start_date
5952: between date_from
5953: and nvl(date_to, hr_api.g_eot);

Line 5957: from per_jobs job

5953: and nvl(date_to, hr_api.g_eot);
5954: */
5955: cursor csr_valid_job is
5956: select job.business_group_id
5957: from per_jobs job
5958: , per_job_groups jgr
5959: where job.job_id = p_job_id
5960: and (p_validation_start_date
5961: between job.date_from

Line 6027: -- Check if the job exists in PER_JOBS where the effective start

6023: -- Check if job is set
6024: --
6025: if p_job_id is not null then
6026: --
6027: -- Check if the job exists in PER_JOBS where the effective start
6028: -- date of the assignment is between the job date from and date to.
6029: --
6030: open csr_valid_job;
6031: fetch csr_valid_job into l_business_group_id;