DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on WF_ROLES

Line 549: select name from wf_roles

545: and trunc(sysdate) between effective_start_date and effective_end_date;
546:
547: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
548: is
549: select name from wf_roles
550: where orig_system_id = p_person_id
551: and orig_system = 'PER';
552:
553: item_key_number number;

Line 724: per_all_people_f people, wf_roles wf

720: cursor get_score_card_role(p_score_card_id in number)
721: IS
722: select wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
723: from per_personal_scorecards sc, per_all_assignments_f asgn,
724: per_all_people_f people, wf_roles wf
725: where sc.scorecard_id = p_score_card_id
726: and asgn.assignment_id = sc.assignment_id
727: and trunc(sysdate) between asgn.effective_start_date and asgn.effective_end_date
728: and asgn.person_id = people.person_id