APPS.HR_WPM_NTF_UTIL dependencies on PER_PERF_MGMT_PLANS

Line 47: CURSOR get_sc_plan_info (p_sc_id per_perf_mgmt_plans.plan_id%TYPE)

43: SELECT person_id
44: FROM per_personal_scorecards
45: WHERE scorecard_id = p_scorecard_id;
46:
47: CURSOR get_sc_plan_info (p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
48: IS
49: SELECT PLAN.hierarchy_type_code, PLAN.supervisor_id, PLAN.supervisor_assignment_id
50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN
51: WHERE sc.scorecard_id = p_sc_id AND sc.plan_id = PLAN.plan_id;

Line 50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN

46:
47: CURSOR get_sc_plan_info (p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
48: IS
49: SELECT PLAN.hierarchy_type_code, PLAN.supervisor_id, PLAN.supervisor_assignment_id
50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN
51: WHERE sc.scorecard_id = p_sc_id AND sc.plan_id = PLAN.plan_id;
52:
53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)
54: IS

Line 60: per_perf_mgmt_plans plans

56: FROM per_personal_scorecards sc,
57: per_all_assignments_f wrk,
58: per_pos_structure_elements ppse,
59: per_all_assignments_f sup,
60: per_perf_mgmt_plans plans
61: WHERE sc.scorecard_id = p_sc_id
62: AND plans.plan_id = sc.plan_id
63: AND sc.assignment_id = wrk.assignment_id
64: AND TRUNC (SYSDATE) BETWEEN wrk.effective_start_date AND wrk.effective_end_date

Line 99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;

95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;
96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;
101: l_top_sup_asg_id per_perf_mgmt_plans.supervisor_assignment_id%TYPE;
102: BEGIN
103:

Line 100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;

96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;
101: l_top_sup_asg_id per_perf_mgmt_plans.supervisor_assignment_id%TYPE;
102: BEGIN
103:
104: /* In case Employee to Manager we need to get the Manager's Person Id */

Line 101: l_top_sup_asg_id per_perf_mgmt_plans.supervisor_assignment_id%TYPE;

97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;
101: l_top_sup_asg_id per_perf_mgmt_plans.supervisor_assignment_id%TYPE;
102: BEGIN
103:
104: /* In case Employee to Manager we need to get the Manager's Person Id */
105: OPEN get_sc_plan_info (score_card_id);