APPS.HR_PSF_BUS dependencies on PER_SPINAL_POINT_STEPS_F

Line 698: l_sequence per_spinal_point_steps_f.sequence%TYPE;

694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
695: )
696: is
697: --
698: l_sequence per_spinal_point_steps_f.sequence%TYPE;
699: l_exists varchar2(1);
700: l_api_updating boolean;
701: l_business_group_id number(15);
702: l_proc varchar2(72) ;

Line 706: from per_spinal_point_steps_f psps

702: l_proc varchar2(72) ;
703: --
704: cursor csr_valid_step is
705: select business_group_id
706: from per_spinal_point_steps_f psps
707: where psps.step_id = p_entry_step_id
708: and p_validation_start_date between psps.effective_start_date and psps.effective_end_date;
709: --
710: cursor csr_valid_step_grade is

Line 713: per_spinal_point_steps_f psps

709: --
710: cursor csr_valid_step_grade is
711: select psps.sequence
712: from per_grade_spines_f pgs,
713: per_spinal_point_steps_f psps
714: where psps.step_id = p_entry_step_id
715: and pgs.grade_id = p_entry_grade_id
716: and pgs.grade_spine_id = psps.grade_spine_id
717: and p_effective_date between pgs.effective_start_date

Line 5551: (p_base_table_name => 'per_spinal_point_steps_f',

5547: hr_utility.set_location(l_proc,60 );
5548: end if;
5549: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and
5550: NOT (dt_api.check_min_max_dates
5551: (p_base_table_name => 'per_spinal_point_steps_f',
5552: p_base_key_column => 'step_id',
5553: p_base_key_value => p_entry_step_id,
5554: p_from_date => p_validation_start_date,
5555: p_to_date => p_validation_end_date))) Then