[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pra.recruitment_activity_id recruitment_activity_id
,pra.internal_posting internal_posting
,pra.external_posting external_posting
,pra.business_group_id business_group_id
,pra.date_start date_start
,pra.name name
,pra.recruiting_site_id recruiting_site_id
,pra.object_version_number object_version_number
,pra.date_end date_end
,pra.posting_content_id posting_content_id
from per_recruitment_activities pra
,irc_posting_contents ipc
where ipc.posting_content_id = pra.posting_content_id
and ipc.posting_content_id between p_start_pkid and p_end_pkid
and (pra.internal_posting is not null or pra.external_posting is not null);
select pfr.business_group_id business_group_id
,pfr.vacancy_id vacancy_id
from per_recruitment_activity_for pfr
where pfr.recruitment_activity_id = p_recruitment_activity_id;
select asg.assignment_id assignment_id
,asg.object_version_number object_version_number
,ppf.current_employee_flag current_employee_flag
from per_all_assignments_f asg
,per_all_people_f ppf
where asg.person_id = ppf.person_id
and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
and asg.recruitment_activity_id = p_recruitment_activity_id;
select irs.recruiting_site_id recruiting_site_id
from irc_all_recruiting_sites irs
where irs.internal = 'Y'
and irs.external = 'N';
select irs.recruiting_site_id recruiting_site_id
from irc_all_recruiting_sites irs
where irs.external = 'Y'
and irs.internal = 'N';
select per_recruitment_activities_s.nextval
from sys.dual;
select 1
from per_recruitment_activities pra
where posting_content_id=p_posting_content_id
and recruiting_site_id=p_recruiting_site_id;
select raa.recruitment_activity_id
from per_recruitment_activities raa
,per_recruitment_activity_for raf
where raa.posting_content_id is not null
and raa.internal_posting='Y'
and raa.recruitment_activity_id=raf.recruitment_activity_id
and exists (select 1
from per_recruitment_activity_for raf2
,per_recruitment_activities raa2
where raf2.vacancy_id=raf.vacancy_id
and raf2.recruitment_activity_id=raa2.recruitment_activity_id
and raa2.internal_posting='Y'
and raf2.recruitment_activity_id <> raf.recruitment_activity_id
and raf2.creation_date < raf.creation_date)
order by 1;
select raa.recruitment_activity_id
from per_recruitment_activities raa
,per_recruitment_activity_for raf
where raa.posting_content_id is not null
and raa.external_posting='Y'
and raa.recruitment_activity_id=raf.recruitment_activity_id
and exists (select 1
from per_recruitment_activity_for raf2
,per_recruitment_activities raa2
where raf2.vacancy_id=raf.vacancy_id
and raf2.recruitment_activity_id=raa2.recruitment_activity_id
and raa2.external_posting='Y'
and raf2.recruitment_activity_id <> raf.recruitment_activity_id
and raf2.creation_date < raf.creation_date)
order by 1;
update per_recruitment_activities
set internal_posting=null
,external_posting=null
where recruitment_activity_id = int_recs.recruitment_activity_id;
update per_recruitment_activities
set internal_posting=null
,external_posting=null
where recruitment_activity_id = ext_recs.recruitment_activity_id;
update per_recruitment_activities
set internal_posting = null
,external_posting = null
,recruiting_site_id = l_internal_site_id
where recruitment_activity_id = csr_rec_activity_rec.recruitment_activity_id;
update per_all_assignments_f asg
set recruitment_activity_id = l_int_ext_rec_id
where recruitment_activity_id = csr_rec_activity_rec.recruitment_activity_id
and not exists(select 1
from per_all_people_f per
where per.person_id=asg.person_id
and asg.effective_start_date
between per.effective_start_date and per.effective_end_date
and per.current_employee_flag <> 'Y'
);
update per_recruitment_activities
set internal_posting=null
,external_posting=null
,recruiting_site_id=l_external_site_id
where recruitment_activity_id = csr_rec_activity_rec.recruitment_activity_id;
update per_recruitment_activities
set internal_posting=null
,external_posting=null
where recruitment_activity_id=csr_rec_activity_rec.recruitment_activity_id;
select irs.recruiting_site_id recruiting_site_id
,irs.site_name site_name
,dbms_lob.substr(irs.posting_url) posting_url
,dbms_lob.substr(irs.redirection_url) redirection_url
from irc_all_recruiting_sites irs
where not exists (select null
from irc_all_recruiting_sites_tl itl
where itl.recruiting_site_id = irs.recruiting_site_id)
and irs.recruiting_site_id between p_start_pkid and p_end_pkid;
select language_code from fnd_languages
where installed_flag in ('I', 'B');
update irc_all_recruiting_sites irs
set internal_name=upper(site_name)
where internal_name is null
and irs.recruiting_site_id between p_start_pkid and p_end_pkid;