[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) gre_size, puar.tax_unit_id gre_id, htu.name gre_name
from pay_us_asg_reporting puar,
hr_tax_units_v htu
where puar.tax_unit_id=htu.tax_unit_id
and htu.business_group_id=c_business_group_id
and substr(puar.jurisdiction_code,1,2)=
nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
and htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
group by puar.tax_unit_id,htu.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and info.organization_id = p_gre
group by info.organization_id,hoi.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
group by info.organization_id,hoi.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and info.organization_id = p_gre
and exists (select '1' from pay_us_asg_reporting puar
where puar.tax_unit_id = info.organization_id
and puar.jurisdiction_code like p_state||'%')
group by info.organization_id,hoi.name
order by count(*);
select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
count(*) gre_size,info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
and exists (select '1' from pay_us_asg_reporting puar
where puar.tax_unit_id = info.organization_id
and puar.jurisdiction_code like p_state||'%')
group by info.organization_id,hoi.name
order by count(*);
select number_of_copies,
printer,
print_style,
save_output_flag
into copies_buffer,
printer_buffer,
style_buffer,
save_result
from fnd_concurrent_requests
where request_id = fnd_number.canonical_to_number(req_id);
select pdb.run_balance_status
into l_valid_status
from pay_defined_balances pdb,
pay_balance_types pbt,
pay_balance_dimensions pbd
where pdb.legislation_code = 'US'
and pdb.save_run_balance = 'Y'
and pdb.run_balance_status is not null
and pdb.balance_type_id = pbt.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.balance_name = 'SIT Withheld'
and pbd.database_item_suffix = '_GRE_JD_RUN';
/* select pbv.run_balance_status
into l_valid_status
from pay_defined_balances pdb,
pay_balance_types pbt,
pay_balance_validation pbv,
pay_balance_dimensions pbd
where pdb.legislation_code = 'US'
and pdb.save_run_balance = 'Y'
and pdb.balance_type_id = pbt.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.balance_name = 'SIT Withheld'
and pbd.database_item_suffix = '_GRE_JD_RUN'
and pdb.defined_balance_id = pbv.defined_balance_id
and pbv.business_group_id = p_business_group
and nvl(pbv.balance_load_date,
fnd_date.canonical_to_date(p_start_date))
<= fnd_date.canonical_to_date(p_start_date);
select count(*) gre_size,puar.tax_unit_id gre_id,htu.name gre_name
from pay_us_asg_reporting puar,
hr_tax_units_v htu
where puar.tax_unit_id=htu.tax_unit_id
and htu.business_group_id=c_business_group_id
and substr(puar.jurisdiction_code,1,2)=
nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
and htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
group by puar.tax_unit_id,htu.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and info.organization_id = p_gre
group by info.organization_id,hoi.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
group by info.organization_id,hoi.name
order by count(*);
select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and info.organization_id = p_gre
and exists (select '1' from pay_us_asg_reporting puar
where puar.tax_unit_id = info.organization_id
and puar.jurisdiction_code like cv_jurisdiction)
group by info.organization_id,hoi.name
order by count(*);
select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
from hr_organization_units hoi,
hr_organization_information info
where hoi.organization_id = info.organization_id
and info.org_information_context = 'CLASS'
and info.org_information1 = 'HR_LEGAL'
and hoi.business_group_id = p_business_group
and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
and exists (select '1' from pay_us_asg_reporting puar
where puar.tax_unit_id = info.organization_id
and puar.jurisdiction_code like cv_jurisdiction)
group by info.organization_id,hoi.name
order by count(*);
select number_of_copies,
printer,
print_style,
save_output_flag
into copies_buffer,
printer_buffer,
style_buffer,
save_result
from fnd_concurrent_requests
where request_id = fnd_number.canonical_to_number(req_id);
/* Bug 3376256: select the first 6 characters from p_county and assign to c_jurisdiction */
Begin
Select Substr(p_county, 1, 6)
Into lv_County
From Dual;