The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(pee.subpriority, 1)
INTO l_subprio
FROM pay_element_entries_f PEE
WHERE PEE.element_entry_id = p_ele_entry_id
AND p_date_earned
BETWEEN PEE.effective_start_date
AND PEE.effective_end_date;
SELECT pet.element_information1
INTO l_cat
FROM pay_element_types_f pet,
pay_element_links_f pel,
pay_element_entries_f PEE
WHERE PEE.element_entry_id = p_ele_entry_id
AND p_date_earned
BETWEEN PEE.effective_start_date
AND PEE.effective_end_date
AND pel.element_link_id = PEE.element_link_id
AND PEE.effective_start_date between pel.effective_start_date
and pel.effective_end_date
ANd pet.element_type_id = pel.element_type_id
AND pel.effective_start_date between pet.effective_start_date
and pet.effective_end_date;
SELECT fnd_date.canonical_to_date(ev.screen_entry_value)
FROM pay_input_values_f iv,
pay_element_entry_values_f ev
WHERE ev.element_entry_id = p_element_entry_id
AND p_effective_date
BETWEEN ev.effective_start_date and ev.effective_end_date
AND iv.input_value_id = ev.input_value_id
AND iv.name = 'Date Served';
SELECT MIN(effective_start_date)
INTO ld_garn_date
FROM pay_element_entries_f ee
WHERE ee.element_entry_id = p_element_entry_id;
SELECT target.max_withholding_duration_days
INTO ln_garn_limit_days
FROM PAY_US_GARN_LIMIT_RULES_F target,
PAY_ELEMENT_TYPES_F pet
WHERE target.state_code = SUBSTR(p_jursd_code,1,2)
AND target.garn_category = pet.element_information1
AND ld_garn_date BETWEEN target.effective_start_date
AND target.effective_end_date
AND pet.element_type_id = p_element_type_id;
/* Commenting the section below as per the Update by Nora Daly
in Bug# 6140374 on 07/16/07 11:16 am
AND ld_garn_date
BETWEEN pet.effective_start_date AND pet.effective_end_date;