[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
from fnd_sessions
where session_id=userenv('sessionid');
select tl.name
from hr_all_organization_units_tl tl,
hr_all_organization_units hou
where hou.organization_id=p_organization_id
and tl.organization_id=hou.organization_id
and tl.language=userenv('LANG');
select address_line_1
from per_jp_address_lookups
where district_code=p_district_code;
select pad.address_line1 || pad.address_line2 || pad.address_line3
from per_addresses pad
where pad.person_id=p_person_id
and pad.address_type=p_address_type
and p_effective_date
between pad.date_from and nvl(pad.date_to,p_effective_date);
select pad.town_or_city
from per_addresses pad
where pad.person_id=p_person_id
and pad.address_type=p_address_type
and p_effective_date
between pad.date_from and nvl(pad.date_to,p_effective_date);
select effective_date
from fnd_sessions
where session_id=userenv('sessionid');
select /*+ ORDERED USE_NL(PPA PES PTP) */
'TRUE'
from pay_assignment_actions paa,
pay_payroll_actions ppa,
pay_element_sets pes,
per_time_periods ptp
where paa.assignment_id=p_assignment_id
and ppa.payroll_action_id=paa.payroll_action_id
-- Element set will be supported in near future.
and ppa.action_type in ('R','Q')
and pes.element_set_id=ppa.element_set_id
and pes.element_set_name=p_element_set_name
and ptp.time_period_id=ppa.time_period_id
and l_effective_date
between nvl(p_validation_start_date,ptp.start_date) and nvl(p_validation_end_date,ptp.end_date);
select /*+ NO_INDEX(HOI1 HR_ORGANIZATION_INFORMATIO_IX1)
NO_INDEX(HOI2 HR_ORGANIZATION_INFORMATIO_FK1) */
hoi2.org_information1
,hoi2.org_information2
,hoi2.org_information3
,hoi2.org_information4
,hoi2.org_information5
from
hr_organization_information hoi1
,hr_organization_information hoi2
where
hoi1.organization_id = p_organization_id
and hoi1.org_information_context = 'CLASS'
and hoi1.org_information1 = 'JP_EXTRA_NAME'
and hoi1.org_information2 = 'Y'
and hoi2.org_information_context = 'JP_ORG_SHORT_NAME'
and hoi2.organization_id = hoi1.organization_id
;
select to_char(p_date, p_format, 'NLS_CALENDAR=''Japanese Imperial''')
into l_char
from dual;
select pvr.registration_number
from pqp_vehicle_allocations_f pva,
pqp_vehicle_repository_f pvr
where pva.vehicle_allocation_id=p_vehicle_allocation_id
and p_effective_date
between pva.effective_start_date and nvl(pva.effective_end_date,p_effective_date)
and pvr.vehicle_repository_id = pva.vehicle_repository_id
and p_effective_date
between pvr.effective_start_date and nvl(pvr.effective_end_date,p_effective_date);