[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select wf.name role_name
from wf_roles wf
where wf.orig_system = 'PER'
and wf.orig_system_id = person_id;
select global_name from per_all_people_f
where person_id = p_person_id
and trunc(sysdate) between effective_start_date and effective_end_date;
select * from per_personal_scorecards where scorecard_id = p_scorecard_id;
SELECT paf.supervisor_id
FROM per_all_assignments_f paf
,per_personal_scorecards sc
WHERE sc.scorecard_id = p_sc_id
AND sc.assignment_id = paf.assignment_id
AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
AND paf.assignment_type in ('E','C');
select person_id from per_personal_scorecards
where scorecard_id = p_scorecard_id;
select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan
where sc.scorecard_id = p_sc_id
and sc.plan_id = plan.plan_id;
select sup.person_id
from per_personal_scorecards sc, per_assignments_f wrk,
per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans
where sc.scorecard_id = p_sc_id
and plans.plan_id = sc.plan_id
and sc.assignment_id = wrk.assignment_id
and trunc(sysdate) between wrk.effective_start_date and wrk.effective_end_date
and wrk.position_id = ppse.subordinate_position_id
and ppse.pos_structure_version_id = plans.pos_structure_version_id
and ppse.business_group_id = sup.business_group_id
and ppse.parent_position_id = sup.position_id;