DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on PER_ALL_ASSIGNMENTS_F

Line 723: from per_personal_scorecards sc, per_all_assignments_f asgn,

719:
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