APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 602: FROM per_spinal_point_placements_f

598:
599: -- get placement_id rec
600: CURSOR csr_placement_id IS
601: SELECT placement_id
602: FROM per_spinal_point_placements_f
603: WHERE assignment_id = p_params.assignment_id
604: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
605:
606: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;

Line 636: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

632: if l_placement_id is not null then
633: -- we will be updating spp
634: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';
635:
636: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
637: ,p_dt_flag => 'Y'
638: ,p_pk => 'PLACEMENT_ID'
639: ,p_pk_id => l_placement_id
640: ,p_effective_date => p_params.effective_date