The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT security_profile_id
FROM per_security_profiles
WHERE reporting_oracle_username = USER;
select named_person_id
from per_security_profiles
where security_profile_id=p_security_profile_id;
select employee_id
from fnd_user
where user_id=p_user_id;
SELECT DECODE(READ_ONLY_FLAG,'U', 'Y'
,'M', 'Y'
,'K', 'Y'
,'N') schema_mode,
DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1, 10))
FROM FND_ORACLE_USERID
WHERE ORACLE_USERNAME = user;
SELECT *
FROM per_security_profiles
WHERE security_profile_id = p_security_profile_id;
SELECT fndu.employee_id
FROM fnd_user fndu
WHERE p_user_id IS NOT NULL
AND fndu.user_id = p_user_id;
select person_id
from per_person_list
where security_profile_id=p_security_profile_id
and granted_user_id is null;
select asg.person_id
from (select a.person_id,
a.supervisor_id
from per_all_assignments_f a
where trunc(sysdate) between a.effective_start_date
and a.effective_end_date
and assignment_type <> 'B') asg
connect by asg.supervisor_id = prior asg.person_id
and Level<=nvl(p_max_levels,Level)+1
start with asg.person_id=p_top_person_id;
select asg.person_id
from (select a.person_id,
a.supervisor_id
from per_all_assignments_f a
where trunc(sysdate) between a.effective_start_date
and a.effective_end_date
and assignment_type <> 'B') asg
where exists (select null
from per_person_list ppl
where ppl.security_profile_id=p_security_profile_id
and ppl.person_id=asg.person_id)
connect by asg.supervisor_id = prior asg.person_id
and Level<=nvl(p_max_levels,Level)+1
start with asg.person_id=p_top_person_id ;
select asg.person_id
from (select a.person_id,
a.supervisor_id
from per_all_assignments_f a
where trunc(sysdate) between a.effective_start_date
and a.effective_end_date
and assignment_type <> 'B'
and a.primary_flag='Y') asg
connect by asg.supervisor_id = prior person_id
and Level<=nvl(p_max_levels,Level)+1
start with asg.person_id=p_top_person_id ;
select asg.person_id
from (select a.person_id,
a.supervisor_id
from per_all_assignments_f a
where trunc(sysdate) between a.effective_start_date
and a.effective_end_date
and assignment_type <> 'B'
and a.primary_flag='Y' ) asg
where exists (select null
from per_person_list ppl
where ppl.security_profile_id=p_security_profile_id
and ppl.person_id=asg.person_id)
connect by asg.supervisor_id = prior asg.person_id
and Level<=nvl(p_max_levels,Level)+1
start with asg.person_id=p_top_person_id ;
hr_security_internal.g_per_tbl.delete(g_person_id);
SELECT 1
FROM per_organization_list
WHERE security_profile_id = get_security_profile
AND organization_id = p_organization_id;
SELECT 1
FROM per_position_list
WHERE security_profile_id = get_security_profile
AND position_id = p_position_id;
SELECT 1
FROM pay_payroll_list
WHERE security_profile_id = get_security_profile
AND payroll_id = p_payroll_id;
Select 1
from irc_rec_team_members team
,per_all_people_f per
,fnd_user usr
where team.vacancy_id = p_vacancy_id
and team.party_id = nvl(per.party_id, usr.customer_id)
and per.person_id(+) = usr.employee_id
and sysdate between per.effective_start_date
and per.effective_end_date
and usr.user_id = g_user_id;
SELECT null
FROM org_access oa
WHERE oa.resp_application_id = g_resp_appl_id
AND oa.responsibility_id = g_resp_id;
SELECT oa.organization_id
FROM org_access oa
WHERE oa.resp_application_id = g_resp_appl_id
AND oa.responsibility_id = g_resp_id
AND oa.organization_id = p_org_id;
SELECT null
FROM hr_organization_information oi
WHERE oi.organization_id = p_org_id
AND oi.org_information_context = 'Accounting Information'
AND to_number(oi.org_information3) = org_id;
hr_security_internal.g_per_tbl.delete(p_person_id);
PROCEDURE delete_list_for_bg(p_business_group_id NUMBER)
IS
BEGIN
hr_security_internal.delete_security_list_for_bg(p_business_group_id);
PROCEDURE delete_per_from_list(p_person_id number)
IS
BEGIN
hr_security_internal.delete_per_from_security_list(p_person_id);
PROCEDURE delete_org_from_list(p_organization_id number)
IS
BEGIN
hr_security_internal.delete_org_from_security_list(p_organization_id);
PROCEDURE delete_pos_from_list(p_position_id number)
IS
BEGIN
hr_security_internal.delete_pos_from_security_list(p_position_id);
PROCEDURE delete_payroll_from_list(p_payroll_id number)
IS
BEGIN
hr_security_internal.delete_pay_from_security_list(p_payroll_id);