DBA Data[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 610: FROM per_spinal_point_placements_f

606:
607: -- get placement_id rec
608: CURSOR csr_placement_id IS
609: SELECT placement_id
610: FROM per_spinal_point_placements_f
611: WHERE assignment_id = p_params.assignment_id
612: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
613:
614: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;

Line 644: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

640: if l_placement_id is not null then
641: -- we will be updating spp
642: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';
643:
644: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
645: ,p_dt_flag => 'Y'
646: ,p_pk => 'PLACEMENT_ID'
647: ,p_pk_id => l_placement_id
648: ,p_effective_date => p_params.effective_date