[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) into l_count from fii_ccc_mgr_gt;
insert /*+ append parallel(a) */ into fii_ccc_mgr_gt a (manager, ccc_org_id, company_id, cost_center_id)
select /*+ use_hash(ccc_tbl,mgr_tbl,org,fv1,fv2) parallel(ccc_tbl) parallel(org) parallel(fv1) parallel(fv2) pq_distribute(fv1 hash,hash) pq_distribute(fv2 hash,hash) */
to_number (mgr_tbl.org_information2) manager,
ccc_tbl.organization_id ccc_org_id,
fv1.flex_value_id com_id,
fv2.flex_value_id cc_id
from hr_organization_information ccc_tbl,
( select /*+ parallel(b) */ organization_id, org_information2
from hr_organization_information b
where org_information_context = 'Organization Name Alias'
and nvl( fnd_date.canonical_to_date( org_information3 ),
sysdate + 1 ) <= sysdate
and nvl( fnd_date.canonical_to_date( org_information4 ),
sysdate + 1 ) >= sysdate
) mgr_tbl,
hr_organization_information org,
fnd_flex_values fv1,
fnd_flex_values fv2
where ccc_tbl.org_information_context = 'CLASS'
and ccc_tbl.org_information1 = 'CC'
and ccc_tbl.org_information2 = 'Y'
and ccc_tbl.organization_id = mgr_tbl.organization_id (+)
and org.org_information_context = 'Company Cost Center'
and org.organization_id = ccc_tbl.organization_id
and fv1.flex_value_set_id = org.org_information2
and fv1.flex_value = org.org_information3
and fv2.flex_value_set_id = org.org_information4
and fv2.flex_value = org.org_information5;
fii_util.put_line( 'Inserted ' || l_count || ' rows' );
select distinct ou.name
from fii_ccc_mgr_gt gt, hr_all_organization_units ou
where gt.manager is null
and gt.ccc_org_id = ou.organization_id
and (to_date(to_char(date_to,'mm/dd/yyyy'),'mm/dd/yyyy') >= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'mm/dd/yyyy')
or date_to is null);
select f1.FLEX_VALUE_SET_ID ,flex_value_id
INTO p_UNASSIGNED_VSET_ID, p_UNASSIGNED_ID
from fnd_flex_value_sets f1 ,fnd_flex_values f2
where flex_value_set_name = 'Financials Intelligence Internal Value Set'
and f1.flex_value_set_id = f2.flex_value_set_id
and flex_value = 'UNASSIGNED';