APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PERSONAL_SCORECARDS

Line 50: FROM per_personal_scorecards sc,

46: IS
47: SELECT DISTINCT ppf.person_id,
48: usr.NAME user_name,
49: ppf.full_name
50: FROM per_personal_scorecards sc,
51: per_assignments_f paf,
52: per_people_f ppf,
53: wf_roles usr
54: WHERE sc.plan_id = p_plan_id

Line 71: FROM per_personal_scorecards sc,

67: IS
68: SELECT DISTINCT ppf.person_id,
69: usr.NAME user_name,
70: ppf.full_name
71: FROM per_personal_scorecards sc,
72: per_assignments_f paf,
73: per_people_f ppf,
74: wf_roles usr
75: WHERE sc.plan_id = p_plan_id

Line 84: FROM per_personal_scorecards

80: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
81: AND paf.supervisor_id = usr.orig_system_id(+)
82: AND usr.orig_system(+) = 'PER'
83: AND paf.supervisor_id IN (SELECT person_id
84: FROM per_personal_scorecards
85: WHERE plan_id = p_plan_id);
86:
87: --
88: --

Line 95: FROM per_personal_scorecards sc,

91: IS
92: SELECT DISTINCT ppf.person_id,
93: usr.NAME user_name,
94: ppf.full_name
95: FROM per_personal_scorecards sc,
96: per_assignments_f paf,
97: per_people_f ppf,
98: wf_roles usr
99: WHERE sc.plan_id = p_plan_id

Line 117: FROM per_personal_scorecards sc,

113: IS
114: SELECT DISTINCT ppf.person_id,
115: usr.NAME user_name,
116: ppf.full_name
117: FROM per_personal_scorecards sc,
118: per_assignments_f paf,
119: per_people_f ppf,
120: wf_roles usr
121: WHERE sc.plan_id = p_plan_id

Line 139: per_personal_scorecards sc,

135: SELECT DISTINCT ppf.person_id,
136: usr.NAME user_name,
137: ppf.full_name
138: FROM per_assignments_f paf,
139: per_personal_scorecards sc,
140: per_people_f ppf,
141: wf_roles usr
142: WHERE sc.plan_id = p_plan_id
143: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 161: per_personal_scorecards sc,

157: SELECT DISTINCT ppf.person_id,
158: usr.NAME user_name,
159: ppf.full_name
160: FROM per_assignments_f paf,
161: per_personal_scorecards sc,
162: per_people_f ppf,
163: wf_roles usr
164: WHERE sc.plan_id = p_plan_id
165: AND p_effective_date BETWEEN sc.start_date AND sc.end_date