The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_update in boolean default TRUE) return boolean is
-------------------------------------------------------------------------------
begin
return icx_sec.VALIDATESESSION(P_FUNC, '', P_COMMIT, P_UPDATE);
SELECT DISTINCT(NVL(FL.ORG_ID,FD.ORG_ID))
INTO L_ORG_ID
FROM AP_EXPENSE_FEED_LINES_ALL FL,
AP_EXPENSE_FEED_DISTS_ALL FD
WHERE FL.EMPLOYEE_VERIFICATION_ID = P_ID
OR (FD.FEED_LINE_ID = FL.FEED_LINE_ID AND
FD.EMPLOYEE_VERIFICATION_ID = P_ID);
SELECT DISTINCT(ORG_ID)
INTO L_ORG_ID
FROM AP_EXPENSE_FEED_DISTS_ALL
WHERE MANAGER_APPROVAL_ID = P_ID;
SELECT 1
INTO v_numRows
FROM DUAL
WHERE EXISTS
(SELECT 1
FROM
per_cont_workers_current_x p
WHERE
p.person_id = p_person_id);
select GS.chart_of_accounts_id
into p_chart_of_accounts
from ap_system_parameters S,
gl_sets_of_books GS
where GS.set_of_books_id = S.set_of_books_id;
select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
from fnd_flex_value_sets
where flex_value_set_name like p_value_set_name
and PARENT_FLEX_VALUE_SET_ID is not null;
SELECT s.segment_num into p_dependent_seg_num
FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
fnd_segment_attribute_types sat
WHERE s.application_id = 101
AND s.id_flex_code = 'GL#'
AND s.id_flex_num = p_chart_of_accounts_id
AND s.enabled_flag = 'Y'
AND s.application_column_name = sav.application_column_name
AND sav.application_id = 101
AND sav.id_flex_code = 'GL#'
AND sav.id_flex_num = p_chart_of_accounts_id
AND sav.attribute_value = 'Y'
AND sav.segment_attribute_type = sat.segment_attribute_type
AND sat.application_id = 101
AND sat.id_flex_code = 'GL#'
AND sat.unique_flag = 'Y'
AND s.FLEX_VALUE_SET_ID=l_parent_flex_value_set_id
AND rownum =1;
SELECT emp.set_of_books_id, emp.default_code_combination_id
INTO l_emp_set_of_books_id, l_default_emp_ccid
FROM per_employees_x emp
WHERE emp.employee_id = l_employee_id;
SELECT emp.set_of_books_id, emp.default_code_combination_id
INTO l_emp_set_of_books_id, l_default_emp_ccid
FROM per_cont_workers_current_x emp
WHERE emp.person_id = l_employee_id;
SELECT GS.chart_of_accounts_id
INTO l_emp_chart_of_accounts_id
FROM gl_sets_of_books GS
WHERE GS.set_of_books_id = l_emp_set_of_books_id;