The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
into l_effective_date
from fnd_sessions
where session_id = userenv('SESSIONID');
select 'X'
from hr_organization_information hoi
where (
(
p_date_from between fnd_date.canonical_to_date(hoi.org_information1)
and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
,fnd_date.canonical_to_date(hoi.org_information2))
)
or
(
l_end_date between fnd_date.canonical_to_date(hoi.org_information1)
and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
,fnd_date.canonical_to_date(hoi.org_information2))
)
or
(
l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
,fnd_date.canonical_to_date(hoi.org_information2))
and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)
)
)
and hoi.org_information_context = decode(p_information_type,'FR_ESTAB_ROBIEN',
'FR_ESTAB_AUBRY_I','FR_ESTAB_ROBIEN')
and hoi.organization_id = p_org_id;
select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
paa.assignment_action_id),16))
from pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_id = p_assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date between
pay_fr_general.g_prev_start_date and
pay_fr_general.g_prev_end_date
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
select creator_id
from ff_user_entities
where user_entity_name = p_balance_name;