APPS.PER_SPS_BUS dependencies on HR_ALL_POSITIONS_F

Line 673: -- per_spinal_point_placement_f, per_all_assignments_f and hr_all_positions_f

669: -- ---------------------------------------------------------------------------
670: --
671: -- Description
672: -- This procedure is used to check that there are no values in
673: -- per_spinal_point_placement_f, per_all_assignments_f and hr_all_positions_f
674: --
675: -- Pre Conditions
676: -- None.
677: --

Line 728: from hr_all_positions_f

724: -- and p_date < effective_end_date;
725: --
726: cursor csr_position(p_date date) is
727: select 'X'
728: from hr_all_positions_f
729: where entry_step_id = p_step_id
730: and p_date < effective_end_date;
731:
732:

Line 791: -- Check on hr_all_positions_f

787: hr_utility.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc, 30);
791: -- Check on hr_all_positions_f
792: open csr_position(l_date);
793: fetch csr_position into l_exists3;
794: close csr_position;
795: if l_exists3 = 'X' then

Line 1302: (p_base_table_name => 'hr_all_positions_f'

1298:
1299: hr_utility.set_location(l_proc, 30);
1300:
1301: If (dt_api.rows_exist
1302: (p_base_table_name => 'hr_all_positions_f'
1303: ,p_base_key_column => 'entry_step_id'
1304: ,p_base_key_value => p_step_id
1305: ,p_from_date => p_validation_start_date
1306: ,p_to_date => p_validation_end_date