APPS.PER_ABV_PKG SQL Statements

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

Line: 34

select 'x'
from   per_assignment_budget_values
where  assignment_id = p_assignment_id
and    unit = p_unit
AND    ((p_rowid IS NULL)
OR      (p_rowid is not null and
         rowid <> chartorowid(p_rowid))
       );

Line: 57

select per_assignment_budget_values_s.nextval
from sys.dual;

Line: 88

select meaning
from hr_lookups
where lookup_type = 'BUDGET_MEASUREMENT_TYPE'
and   lookup_code = p_unit;

Line: 114

select MAX(effective_end_date)
from per_all_assignments_f
where assignment_id = p_assignment_id;

Line: 149

 select null
 from   PER_ASSIGNMENT_BUDGET_VALUES_F
 where  assignment_id          = p_assignment_id
 and    unit                   = p_unit
 and    effective_start_date  <= p_end_date
 and    effective_end_date    >= p_start_date;