The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fed_information1, -- DBP Payback Limit
fed_information2, -- DCP Combined EE ER Limit
fed_information3, -- Includable Annual Comp Limit
fed_information4, -- Includable Annual Comp GF Limit
fed_information5, -- DCP EE Contribution Limit
fed_information6 -- DBP Contribution Limit (%age)
FROM pay_us_federal_tax_info_f
WHERE p_effective_date BETWEEN effective_start_date
AND effective_end_date
AND fed_information_category = 'SRS LIMITS';
SELECT effective_date, business_group_id
FROM pay_payroll_actions
WHERE payroll_action_id= p_payroll_action_id;
SELECT EEI_INFORMATION4
FROM PAY_ELEMENT_TYPE_EXTRA_INFO
WHERE element_type_id = c_element_type_id
AND information_type = c_information_type ;
SELECT aei_information5,
aei_information6
FROM per_assignment_extra_info paei,
pay_element_types_f pet
WHERE assignment_id = c_assignment_id
AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO'
AND aei_information4 = pet.element_name
AND element_type_id = c_element_type_id
AND c_effective_date
BETWEEN NVL(TO_DATE(SUBSTR(aei_information1,1,10),'yyyy/mm/dd')
,c_effective_date)
AND NVL(TO_DATE(SUBSTR(aei_information2,1,10),'yyyy/mm/dd')
,c_effective_date)
AND c_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
Select pet.element_type_id
from pay_element_types_f pet
Where pet.element_name = c_element_name
and pet.business_group_id = c_business_group_id
and c_effective_date between pet.effective_start_date
and pet.effective_end_date;
SELECT aei_information4,
aei_information5,
aei_information6
FROM per_assignment_extra_info paei
WHERE assignment_id = c_assignment_id
AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO';