DBA Data[Home] [Help]

APPS.HR_SALARY_SURVEY_MAPPING_API dependencies on HR_POSITIONS_F

Line 605: -- Changes 13-Oct-99 SCNair (per_positions to hr_positions_f)Date tracked position req

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: --
607: cursor csr_get_position_dates is
608: select p.date_effective, nvl(hr_general.get_position_date_end(p.position_id), hr_general.end_of_time)
609: from hr_positions_f p

Line 609: from hr_positions_f p

605: -- Changes 13-Oct-99 SCNair (per_positions to hr_positions_f)Date tracked position req
606: --
607: cursor csr_get_position_dates is
608: select p.date_effective, nvl(hr_general.get_position_date_end(p.position_id), hr_general.end_of_time)
609: from hr_positions_f p
610: where p.position_id = p_position_id
611: and p.effective_end_date = hr_general.end_of_time;
612: --
613: cursor csr_get_mappings(c_table_name per_salary_survey_mappings.parent_table_name%TYPE) is