APPS.HR_PSF_BUS dependencies on PER_JOBS_V

Line 2036: from per_jobs_v job

2032: l_vac_job_id hr_positions_f.job_id%TYPE;
2033: --
2034: cursor csr_valid_job_id is
2035: select 'x'
2036: from per_jobs_v job
2037: where job.job_id = p_job_id
2038: and job.business_group_id + 0 = p_business_group_id;
2039: --
2040: cursor csr_valid_job_dates(p_validation_date date) is

Line 2042: from per_jobs_v job

2038: and job.business_group_id + 0 = p_business_group_id;
2039: --
2040: cursor csr_valid_job_dates(p_validation_date date) is
2041: select 'x'
2042: from per_jobs_v job
2043: where job.job_id = p_job_id
2044: and p_validation_date between job.date_from
2045: and nvl(job.date_to,hr_api.g_eot);
2046: --