APPS.HR_PERINFO_UTIL_WEB SQL Statements

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

Line: 17

select PRODUCT_VERSION
from FND_PRODUCT_INSTALLATIONS
where APPLICATION_ID = p_application_id;

Line: 67

	SELECT min(pp.effective_start_date)
	FROM   per_all_people_f pp
	WHERE  pp.person_id = p_person_id;

Line: 118

	SELECT 'Y'
	FROM   per_all_people_f pp
	WHERE  pp.person_id = p_person_id
	AND    pp.object_version_number = p_ovn
	AND    trunc(p_effective_date) < trunc(pp.effective_start_date);