DBA Data[Home] [Help]

APPS.HR_SALARY_SURVEY_MAPPING_API dependencies on HR_GENERAL

Line 608: select p.date_effective, nvl(hr_general.get_position_date_end(p.position_id), hr_general.end_of_time)

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
610: where p.position_id = p_position_id
611: and p.effective_end_date = hr_general.end_of_time;
612: --

Line 611: and p.effective_end_date = hr_general.end_of_time;

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
614: select ssm.location_id location_id,
615: ssm.grade_id grade_id,