APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PERSONAL_SCORECARDS

Line 42: FROM per_personal_scorecards sc

38: p_effective_date DATE) IS
39: SELECT distinct ppf.person_id,
40: usr.name user_name,
41: ppf.full_name
42: FROM per_personal_scorecards sc
43: ,per_assignments_f paf
44: ,per_people_f ppf
45: ,wf_roles usr
46: WHERE sc.plan_id = p_plan_id

Line 61: FROM per_personal_scorecards sc

57: p_effective_date DATE) IS
58: SELECT DISTINCT ppf.person_id,
59: usr.name user_name,
60: ppf.full_name
61: FROM per_personal_scorecards sc
62: ,per_assignments_f paf
63: ,per_people_f ppf
64: ,wf_roles usr
65: WHERE sc.plan_id = p_plan_id

Line 82: FROM per_personal_scorecards sc

78: ,p_status IN VARCHAR2) IS
79: SELECT distinct ppf.person_id
80: ,usr.name user_name
81: ,ppf.full_name
82: FROM per_personal_scorecards sc
83: ,per_assignments_f paf
84: ,per_people_f ppf
85: ,wf_roles usr
86: WHERE sc.plan_id = p_plan_id

Line 104: FROM per_personal_scorecards sc

100: ,p_status IN VARCHAR2) IS
101: SELECT distinct ppf.person_id
102: ,usr.name user_name
103: ,ppf.full_name
104: FROM per_personal_scorecards sc
105: ,per_assignments_f paf
106: ,per_people_f ppf
107: ,wf_roles usr
108: WHERE sc.plan_id = p_plan_id

Line 125: ,per_personal_scorecards sc

121: SELECT DISTINCT ppf.person_id
122: ,usr.name user_name
123: ,ppf.full_name
124: FROM per_assignments_f paf
125: ,per_personal_scorecards sc
126: ,per_people_f ppf
127: ,wf_roles usr
128: WHERE sc.plan_id = p_plan_id
129: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 145: ,per_personal_scorecards sc

141: SELECT DISTINCT ppf.person_id
142: ,usr.name user_name
143: ,ppf.full_name
144: FROM per_assignments_f paf
145: ,per_personal_scorecards sc
146: ,per_people_f ppf
147: ,wf_roles usr
148: WHERE sc.plan_id = p_plan_id
149: AND p_effective_date BETWEEN sc.start_date AND sc.end_date