DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on WF_ROLES

Line 156: select name from wf_roles

152: and trunc(sysdate) between effective_start_date and effective_end_date;
153:
154: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
155: is
156: select name from wf_roles
157: where orig_system_id = p_person_id
158: and orig_system = 'PER';
159:
160: item_key_number number;

Line 331: per_all_people_f people, wf_roles wf

327: cursor get_score_card_role(p_score_card_id in number)
328: IS
329: select wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
330: from per_personal_scorecards sc, per_all_assignments_f asgn,
331: per_all_people_f people, wf_roles wf
332: where sc.scorecard_id = p_score_card_id
333: and asgn.assignment_id = sc.assignment_id
334: and sysdate between asgn.effective_start_date and asgn.effective_end_date
335: and asgn.person_id = people.person_id