APPS.PER_SPINAL_POINTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

select 'x'
from per_spinal_points
where spinal_point = p_spoint
and parent_spine_id = p_pspine_id
and ((p_rowid is null)
 or (p_rowid is not null and chartorowid(p_rowid) <> rowid));

Line: 44

select 'x'
from per_spinal_points
where sequence = p_seq
and parent_spine_id = p_pspine_id
and ((p_rowid is null)
 or  (p_rowid is not null and chartorowid(p_rowid) <> rowid));

Line: 71

procedure rules_steps_update(p_seq IN NUMBER,
                       p_spoint_id IN NUMBER) is

begin
--
begin
--
update pay_grade_rules_f
set sequence = p_seq
where rate_type = 'SP'
and grade_or_spinal_point_id = p_spoint_id;

Line: 87

update per_spinal_point_steps
set sequence = p_seq
where spinal_point_id = p_spoint_id;

Line: 93

end rules_steps_update;

Line: 100

select per_spinal_points_s.nextval
from sys.dual;

Line: 123

select 'x'
from per_spinal_point_steps_f f,
     per_grade_spines g
where f.grade_spine_id = g.grade_spine_id
and g.parent_spine_id = p_pspine_id
and f.spinal_point_id = p_spoint_id;

Line: 131

select 'x'
from pay_grade_rules_f
where grade_or_spinal_point_id = p_spoint_id
and rate_type = 'SP';