APPS.PER_ASG_BUS1 dependencies on PER_JOBS

Line 6075: from per_jobs_v

6071: -- Description : Changed the cursor sql query to improve the performance
6072: --
6073: /* cursor csr_valid_job is
6074: select business_group_id
6075: from per_jobs_v
6076: where job_id = p_job_id
6077: and p_validation_start_date
6078: between date_from
6079: and nvl(date_to, hr_api.g_eot);

Line 6083: from per_jobs job

6079: and nvl(date_to, hr_api.g_eot);
6080: */
6081: cursor csr_valid_job is
6082: select job.business_group_id
6083: from per_jobs job
6084: , per_job_groups jgr
6085: where job.job_id = p_job_id
6086: and (p_validation_start_date
6087: between job.date_from

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

6149: -- Check if job is set
6150: --
6151: if p_job_id is not null then
6152: --
6153: -- Check if the job exists in PER_JOBS where the effective start
6154: -- date of the assignment is between the job date from and date to.
6155: --
6156: open csr_valid_job;
6157: fetch csr_valid_job into l_business_group_id;