APPS.PER_PARENT_SPINES_PKG SQL Statements

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

Line: 11

select 'x'
from per_parent_spines
where upper(name) = upper(p_name)
and (p_rowid is null
 or (p_rowid is not null and chartorowid(p_rowid) <> rowid))
and business_group_id + 0 = p_bgroup_id;

Line: 44

select 'x'
from per_spinal_points
where parent_spine_id = p_pspine_id;

Line: 49

select 'x'
from per_grade_spines_f
where parent_spine_id = p_pspine_id;

Line: 54

select 'x'
from pay_rates
where parent_spine_id = p_pspine_id;

Line: 109

select per_parent_spines_s.nextval
from sys.dual;

Line: 130

select meaning
from hr_lookups
where lookup_type = 'FREQUENCY'
and lookup_code = p_incp;