DBA Data[Home] [Help]

APPS.PQH_GSP_DEFAULT dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 469: from per_spinal_point_placements_f

465: where assignment_id = p_assignment_id
466: and l_asg_check_date between effective_start_date and effective_end_date;
467: cursor csr_spps is
468: select step_id
469: from per_spinal_point_placements_f
470: where assignment_id = p_assignment_id
471: and l_asg_check_date between effective_start_date and effective_end_date;
472: begin
473: hr_utility.set_location('inside next_asg_grade_step',10);

Line 992: from per_spinal_point_placements_f

988: begin
989: hr_utility.set_location('assignment is'||p_assignment_id,10);
990: select step_id,increment_number
991: into p_emp_step_id,p_num_incr
992: from per_spinal_point_placements_f
993: where assignment_id = p_assignment_id
994: and p_effective_date between effective_start_date and effective_end_date;
995: hr_utility.set_location('step is'||p_emp_step_id,15);
996: exception