APPS.PAY_PAYFV_ELEMENT_ENTRIES_PKG SQL Statements

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

Line: 31

select 	name
into	l_name
from   	per_jobs_vl
where 	job_id = p_job_id;

Line: 50

select 	name
into	l_name
from   	per_positions
where 	position_id = p_pos_id;

Line: 69

select 	name
into	l_name
from   	per_grades_vl
where 	grade_id = p_grade_id;

Line: 88

select 	location_code
into	l_location
from   	hr_locations_all_tl
where 	location_id = p_loc_id
and     language    = userenv('LANG');

Line: 108

select 	pay_basis
into	l_basis
from   	per_pay_bases
where 	pay_basis_id = p_pay_id;

Line: 127

select  payroll_name
into    l_payroll
from    pay_payrolls_f
where   payroll_id = p_payroll_id
and     sysdate    between effective_start_date
                   and     effective_end_date;