APPS.HR_WPM_NTF_UTIL dependencies on PER_PERF_MGMT_PLANS

Line 44: cursor get_sc_plan_info(p_sc_id per_perf_mgmt_plans.plan_id%TYPE)

40: is
41: select person_id from per_personal_scorecards
42: where scorecard_id = p_scorecard_id;
43:
44: cursor get_sc_plan_info(p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
45: is
46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan
47: where sc.scorecard_id = p_sc_id
48: and sc.plan_id = plan.plan_id;

Line 46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan

42: where scorecard_id = p_scorecard_id;
43:
44: cursor get_sc_plan_info(p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
45: is
46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan
47: where sc.scorecard_id = p_sc_id
48: and sc.plan_id = plan.plan_id;
49:
50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)

Line 54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans

50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)
51: is
52: select sup.person_id
53: from per_personal_scorecards sc, per_assignments_f wrk,
54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans
55: where sc.scorecard_id = p_sc_id
56: and plans.plan_id = sc.plan_id
57: and sc.assignment_id = wrk.assignment_id
58: and trunc(sysdate) between wrk.effective_start_date and wrk.effective_end_date

Line 80: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;

76: sc_person_id per_personal_scorecards.person_id%TYPE default null;
77: from_person_id per_all_people_f.person_id%TYPE default null;
78: to_person_id per_all_people_f.person_id%TYPE default null;
79: mesg_name varchar2(100) default null;
80: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
81:
82: BEGIN
83: /* In case Employee to Manager we need to get the Manager's Person Id */
84: