The following lines contain the word 'select', 'insert', 'update' or 'delete':
on the Task Service Type, or some other task indicator. Customer logic may be inserted
into the function where indicated below.
*/
--Determine if the current Expenditure Type occurs in the POS Exp Types Lookup Set
SELECT COUNT(*)
INTO v_count
FROM pa_lookups
WHERE lookup_type = 'PROCEEDS_OF_SALE_EXP_TYPES'
AND lookup_code = upper(p_expenditure_type); -- Adding upper() for Bug3290556