The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(etype.element_information4, 'NOT ENTERED')
INTO l_ptx_period_type
FROM pay_element_types_f ETYPE
WHERE ETYPE.element_information20 = p_eletype_id
AND p_date_earned BETWEEN ETYPE.effective_start_date
AND ETYPE.effective_end_date;
SELECT NVL(etype.element_information7, 'NOT ENTERED')
INTO l_ptx_row_type
FROM pay_element_types_f ETYPE
WHERE ETYPE.element_information20 = p_eletype_id
AND p_date_earned BETWEEN ETYPE.effective_start_date
AND ETYPE.effective_end_date;
SELECT NVL(etype.element_information6, 'NOT ENTERED')
INTO l_ptx_paytab
FROM pay_element_types_f ETYPE
WHERE ETYPE.element_information20 = p_eletype_id
AND p_date_earned BETWEEN ETYPE.effective_start_date
AND ETYPE.effective_end_date;
SELECT fnd_number.canonical_to_number(BCONTR.employee_contribution)
INTO l_ee_contr
FROM pay_element_types_f PET,
ben_benefit_contributions_f BCONTR
WHERE PET.element_information20 = p_eletype_id
AND BCONTR.element_type_id = PET.element_type_id
AND BCONTR.coverage_type = p_coverage
AND p_date_earned BETWEEN BCONTR.effective_start_date
AND BCONTR.effective_end_date;
SELECT fnd_number.canonical_to_number(BCONTR.employer_contribution)
INTO l_er_contr
FROM pay_element_types_f PET,
ben_benefit_contributions_f BCONTR
WHERE PET.element_information20 = p_eletype_id
AND BCONTR.element_type_id = PET.element_type_id
AND BCONTR.coverage_type = p_coverage
AND p_date_earned BETWEEN BCONTR.effective_start_date
AND BCONTR.effective_end_date;