[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_people_f ppf, wf_roles usr
WHERE ppf.person_id = p_person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_personal_scorecards sc,
per_assignments_f paf,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_personal_scorecards sc,
per_assignments_f paf,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.supervisor_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.supervisor_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER'
AND paf.supervisor_id IN (SELECT person_id
FROM per_personal_scorecards
WHERE plan_id = p_plan_id);
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_personal_scorecards sc,
per_assignments_f paf,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.status_code = p_status
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.supervisor_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.supervisor_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_personal_scorecards sc,
per_assignments_f paf,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.status_code = p_status
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_assignments_f paf,
per_personal_scorecards sc,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.status_code <> 'PUBLISHED'
AND sc.status_code <> 'TRANSFER_OUT'
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_assignments_f paf,
per_personal_scorecards sc,
per_people_f ppf,
wf_roles usr
WHERE sc.plan_id = p_plan_id
AND p_effective_date BETWEEN sc.start_date AND sc.end_date
AND sc.status_code <> 'PUBLISHED'
AND sc.status_code <> 'TRANSFER_OUT'
AND sc.assignment_id = paf.assignment_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.supervisor_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.supervisor_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT paf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr
WHERE apr.plan_id = p_plan_id
AND apr.appraisal_system_status = p_status_code
AND apr.appraisee_person_id = paf.person_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT DISTINCT ppf.person_id,
usr.NAME user_name,
ppf.full_name
FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr
WHERE apr.plan_id = p_plan_id
AND apr.appraisal_system_status = p_status_code
AND apr.main_appraiser_id = paf.person_id
AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND paf.person_id = usr.orig_system_id(+)
AND usr.orig_system(+) = 'PER';
SELECT NAME
FROM wf_roles
WHERE orig_system_id = p_person_id AND orig_system = 'PER';
SELECT a.application_short_name
FROM fnd_new_messages m, fnd_application a
WHERE m.message_name = p_message_name
AND m.language_code = USERENV ('LANG')
AND m.application_id = a.application_id;
SELECT administrator_person_id
INTO l_admin_person_id
FROM per_perf_mgmt_plans
WHERE plan_id = p_plan_id;
SELECT hr_workflow_item_key_s.NEXTVAL
INTO item_key
FROM DUAL;
p_person_selection_rule IN NUMBER DEFAULT NULL
)
IS
l_effective_date DATE;
AND p_person_selection_rule IS NULL
THEN
fnd_message.set_name ('PER', 'PER_NO_POPULATION_TO_NOTIFY');
g_userdtls.DELETE;