APPS.HR_OBJECTIVES_SWI dependencies on PER_PERSONAL_SCORECARDS

Line 39: ,per_personal_scorecards psc

35: cursor chk_shr_instance(p_mgr_scorecard_id in number)
36: is
37: SELECT 'Y'
38: FROM per_scorecard_sharing shr
39: ,per_personal_scorecards psc
40: WHERE shr.scorecard_id = p_mgr_scorecard_id
41: AND psc.scorecard_id = p_scorecard_id
42: AND shr.person_id = psc.person_id;
43: --

Line 47: select person_id from per_personal_scorecards

43: --
44: l_exists varchar2(1);
45: --
46: cursor csr_get_emp_personid is
47: select person_id from per_personal_scorecards
48: where scorecard_id = p_scorecard_id;
49: --
50: l_person_id number;
51: l_cur_person_ovn number;