APPS.HR_SALARY_SURVEY_MAPPING_API dependencies on PER_JOBS

Line 602: from per_jobs j

598: l_grade_id number;
599: --
600: cursor csr_get_job_dates is
601: select j.date_from, nvl(j.date_to, hr_api.g_eot)
602: from per_jobs j
603: where j.job_id = p_job_id;
604: --
605: -- Changes 13-Oct-99 SCNair (per_positions to hr_positions_f)Date tracked position req
606: --

Line 715: l_parent_table_name := 'PER_JOBS';

711: fnd_message.set_name('PER','PER_52498_SSM_JOB_POS_CONT_VAL');
712: fnd_message.raise_error;
713: Elsif p_job_id is not null then
714: hr_utility.set_location(l_proc, 70);
715: l_parent_table_name := 'PER_JOBS';
716: open csr_get_job_dates;
717: fetch csr_get_job_dates into l_parent_date_from, l_parent_date_to;
718: If csr_get_job_dates%NOTFOUND then
719: hr_utility.set_location(l_proc, 80);