The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
from per_all_people_f PER, per_periods_of_service PPS
where per.person_id = g_person_id
and pps.person_id = g_person_id
and p_effective_date between per.effective_start_date
and NVL(per.effective_end_date,hr_api.g_eot)
and p_effective_date between pps.date_start
and NVL(pps.final_process_date,hr_api.g_eot);
g_proc_bon_codes.DELETE;
SELECT element_entry_id
FROM pay_element_entry_values_f
WHERE element_entry_value_id = p_ele_entry_value_id
AND ROWNUM = 1;
l_chg_type := ben_ext_person.g_chg_update_type;
debug('update_type :'||g_pay_proc_evt_tab(l_curr_evt_index).update_type ,20);
SELECT peev.screen_entry_value
FROM pay_element_entry_values_f peev
,pay_input_values_f piv
WHERE peev.element_entry_id = g_curr_element_entry_id
AND peev.input_value_id = piv.input_value_id
AND UPPER(piv.NAME) = 'CLAIM DATE'
--AND peev.effective_start_date = p_effective_date
ORDER BY piv.name;