APPS.PER_WPM_SUMMARY_PKG dependencies on PER_PEOPLE_F

Line 83: per_people_f ppf,

79: ppf2.person_id supervisor_id,
80: pmp.plan_id
81: FROM per_perf_mgmt_plans pmp,
82: per_assignments_f paf,
83: per_people_f ppf,
84: per_people_f ppf2
85: WHERE pmp.plan_id = p_plan_id
86: AND paf.supervisor_id = p_supervisor_id
87: AND paf.primary_flag = 'Y'

Line 84: per_people_f ppf2

80: pmp.plan_id
81: FROM per_perf_mgmt_plans pmp,
82: per_assignments_f paf,
83: per_people_f ppf,
84: per_people_f ppf2
85: WHERE pmp.plan_id = p_plan_id
86: AND paf.supervisor_id = p_supervisor_id
87: AND paf.primary_flag = 'Y'
88: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 201: FROM per_personal_scorecards sc, per_people_f ppf

197: SELECT sc.scorecard_id,
198: sc.person_id,
199: sc.assignment_id,
200: ppf.full_name
201: FROM per_personal_scorecards sc, per_people_f ppf
202: WHERE scorecard_id = p_sc_id
203: AND sc.person_id = ppf.person_id
204: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
205:

Line 213: FROM per_personal_scorecards sc, per_people_f ppf

209: SELECT sc.scorecard_id,
210: sc.person_id,
211: sc.assignment_id,
212: ppf.full_name
213: FROM per_personal_scorecards sc, per_people_f ppf
214: WHERE sc.plan_id = p_plan_id
215: AND sc.person_id = ppf.person_id
216: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
217:

Line 232: FROM per_people_f ppf

228: ,ppf2.full_name "SUPERVISOR_NAME"
229: ,paf.position_id
230: ,paf.organization_id
231: ,ppf.full_name "EMPLOYEE_NAME"
232: FROM per_people_f ppf
233: ,per_all_people_f ppf2
234: ,per_assignments_f paf
235: ,per_personal_scorecards sc
236: ,per_perf_mgmt_plans pln

Line 257: FROM per_people_f ppf

253: ,ppf2.full_name "SUPERVISOR_NAME"
254: ,paf.position_id
255: ,paf.organization_id
256: ,ppf.full_name "EMPLOYEE_NAME"
257: FROM per_people_f ppf
258: ,per_all_people_f ppf2
259: ,per_assignments_f paf
260: ,per_personal_scorecards sc
261: ,per_perf_mgmt_plans pln

Line 283: FROM per_people_f ppf

279: ,ppf2.full_name "SUPERVISOR_NAME"
280: ,paf.position_id
281: ,paf.organization_id
282: ,ppf.full_name "EMPLOYEE_NAME"
283: FROM per_people_f ppf
284: ,per_all_people_f ppf2
285: ,per_assignments_f paf
286: ,per_personal_scorecards sc
287: ,per_perf_mgmt_plans pln

Line 310: supervisor_name per_people_f.full_name%TYPE,

306: LEVEL NUMBER (15),
307: assignment_id NUMBER (15),
308: person_id NUMBER (15),
309: supervisor_id NUMBER (15),
310: supervisor_name per_people_f.full_name%TYPE,
311: position_id NUMBER (15),
312: organization_id NUMBER (15),
313: employee_name per_people_f.full_name%TYPE
314: );

Line 313: employee_name per_people_f.full_name%TYPE

309: supervisor_id NUMBER (15),
310: supervisor_name per_people_f.full_name%TYPE,
311: position_id NUMBER (15),
312: organization_id NUMBER (15),
313: employee_name per_people_f.full_name%TYPE
314: );
315:
316: TYPE t_sc_hrchy IS TABLE OF r_sc_hrchy
317: INDEX BY BINARY_INTEGER;

Line 436: FROM per_perf_mgmt_plans pmp, per_assignments_f paf, per_people_f ppf, per_people_f ppf2

432: ppf.person_id employee_id,
433: ppf2.full_name supervisor_name,
434: ppf2.person_id supervisor_id,
435: pmp.plan_id plan_id
436: FROM per_perf_mgmt_plans pmp, per_assignments_f paf, per_people_f ppf, per_people_f ppf2
437: WHERE pmp.plan_id = p_plan_id
438: AND pmp.supervisor_id = paf.supervisor_id
439: AND paf.primary_flag = 'Y'
440: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 583: per_people_f ppf,

579: SELECT COUNT (*)
580: FROM (SELECT pa.appraisal_id
581: FROM per_appraisals pa,
582: per_wpm_plan_hierarchy wph,
583: per_people_f ppf,
584: per_all_assignments_f paf,
585: per_periods_of_service pps
586: WHERE wph.plan_id = p_plan_id
587: AND wph.supervisor_person_id = p_supervisor_id

Line 612: per_people_f ppf,

608: UNION
609: SELECT pa.appraisal_id
610: FROM per_appraisals pa,
611: per_wpm_plan_hierarchy wph,
612: per_people_f ppf,
613: per_all_assignments_f paf,
614: per_periods_of_placement pps
615: WHERE wph.plan_id = p_plan_id
616: AND wph.supervisor_person_id = p_supervisor_id

Line 652: per_people_f ppf,

648: SELECT COUNT (*)
649: FROM (SELECT pa.appraisal_id
650: FROM per_appraisals pa,
651: per_wpm_plan_hierarchy wph,
652: per_people_f ppf,
653: per_all_assignments_f paf,
654: per_periods_of_service pps
655: WHERE wph.plan_id = p_plan_id
656: AND wph.supervisor_person_id = p_supervisor_id

Line 680: per_people_f ppf,

676: UNION
677: SELECT pa.appraisal_id
678: FROM per_appraisals pa,
679: per_wpm_plan_hierarchy wph,
680: per_people_f ppf,
681: per_all_assignments_f paf,
682: per_periods_of_placement pps
683: WHERE wph.plan_id = p_plan_id
684: AND wph.supervisor_person_id = p_supervisor_id

Line 719: per_people_f ppf,

715: SELECT COUNT (*)
716: FROM (SELECT pa.appraisal_id
717: FROM per_appraisals pa,
718: per_wpm_plan_hierarchy wph,
719: per_people_f ppf,
720: per_all_assignments_f paf,
721: per_periods_of_service pps
722: WHERE wph.plan_id = p_plan_id
723: AND wph.supervisor_person_id = p_supervisor_id

Line 748: per_people_f ppf,

744: UNION
745: SELECT pa.appraisal_id
746: FROM per_appraisals pa,
747: per_wpm_plan_hierarchy wph,
748: per_people_f ppf,
749: per_all_assignments_f paf,
750: per_periods_of_placement pps
751: WHERE wph.plan_id = p_plan_id
752: AND wph.supervisor_person_id = p_supervisor_id

Line 786: per_people_f ppf,

782: SELECT COUNT (*)
783: FROM (SELECT pa.appraisal_id
784: FROM per_appraisals pa,
785: per_wpm_plan_hierarchy wph,
786: per_people_f ppf,
787: per_all_assignments_f paf,
788: per_periods_of_service pps
789: WHERE wph.plan_id = p_plan_id
790: AND wph.supervisor_person_id = p_supervisor_id

Line 814: per_people_f ppf,

810: UNION
811: SELECT pa.appraisal_id
812: FROM per_appraisals pa,
813: per_wpm_plan_hierarchy wph,
814: per_people_f ppf,
815: per_all_assignments_f paf,
816: per_periods_of_placement pps
817: WHERE wph.plan_id = p_plan_id
818: AND wph.supervisor_person_id = p_supervisor_id