APPS.PER_RO_NI_VALIDATION SQL Statements

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

Line: 97

	select LOOKUP_CODE from hr_lookups where LOOKUP_TYPE = 'RO_PER_COUNTIES' and MEANING = county_name;

Line: 129

select extract(YEAR FROM P_DATE_OF_BIRTH) into l_year from dual;

Line: 130

select extract(Month FROM P_DATE_OF_BIRTH) into l_month from dual;

Line: 131

select extract(day FROM P_DATE_OF_BIRTH) into l_date from dual;