APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 462: AND 'x' = ( select 'x' from per_all_people_f ppf

458: asg.effective_start_date AND asg.effective_end_date
459: AND ((p_plan_rec.primary_asg_only_flag = 'N') OR
460: p_plan_rec.primary_asg_only_flag = 'Y' AND
461: asg.primary_flag = 'Y')
462: AND 'x' = ( select 'x' from per_all_people_f ppf
463: where asg.person_id = ppf.person_id
464: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
465: and ('Y' = decode( p_plan_rec.assignment_types_code, 'E', ppf.current_employee_flag, 'C',
466: ppf.current_npw_flag, 'EC', (select 'Y' from dual where

Line 488: AND 'x' = ( select 'x' from per_all_people_f ppf

484: (p_plan_rec.assignment_types_code = 'EC'
485: and asg.assignment_type IN ('E', 'C')))
486: AND p_effective_date BETWEEN
487: asg.effective_start_date AND asg.effective_end_date
488: AND 'x' = ( select 'x' from per_all_people_f ppf
489: where asg.person_id = ppf.person_id
490: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
491: and ('Y' = decode( p_plan_rec.assignment_types_code, 'E', ppf.current_employee_flag, 'C',
492: ppf.current_npw_flag, 'EC', (select 'Y' from dual where

Line 517: AND 'x' = ( select 'x' from per_all_people_f ppf

513: asg.effective_start_date AND asg.effective_end_date
514: AND ((p_plan_rec.primary_asg_only_flag = 'N') OR
515: p_plan_rec.primary_asg_only_flag = 'Y' AND
516: asg.primary_flag = 'Y')
517: AND 'x' = ( select 'x' from per_all_people_f ppf
518: where asg.person_id = ppf.person_id
519: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
520: and ('Y' = decode( p_plan_rec.assignment_types_code, 'E', ppf.current_employee_flag, 'C',
521: ppf.current_npw_flag, 'EC', (select 'Y' from dual where

Line 555: AND 'x' = ( select 'x' from per_all_people_f ppf

551: asg.effective_start_date AND asg.effective_end_date
552: AND ((p_plan_rec.primary_asg_only_flag = 'N') OR
553: p_plan_rec.primary_asg_only_flag = 'Y' AND
554: asg.primary_flag = 'Y')
555: AND 'x' = ( select 'x' from per_all_people_f ppf
556: where asg.person_id = ppf.person_id
557: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
558: and ('Y' = decode( p_plan_rec.assignment_types_code, 'E', ppf.current_employee_flag, 'C',
559: ppf.current_npw_flag, 'EC', (select 'Y' from dual where

Line 5805: ,per_all_people_f suppapf

5801: ,paaf.supervisor_assignment_id
5802: ,suppapf.full_name SUPERVISOR_NAME
5803: FROM per_people_f papf
5804: ,per_assignments_f paaf
5805: ,per_all_people_f suppapf
5806: WHERE paaf.assignment_id = p_assignment_id
5807: AND papf.person_id = paaf.person_id
5808: AND p_effective_date BETWEEN papf.effective_start_date AND
5809: papf.effective_end_date

Line 6523: p_full_name per_all_people_f.full_name%type

6519: --
6520: procedure send_message_notification (p_person_id in number,
6521: p_message varchar2,
6522: p_plan_id per_perf_mgmt_plans.plan_id%type default null,
6523: p_full_name per_all_people_f.full_name%type
6524: )
6525: is
6526:
6527: cursor get_role(person_id per_all_people_f.person_id%TYPE)

Line 6527: cursor get_role(person_id per_all_people_f.person_id%TYPE)

6523: p_full_name per_all_people_f.full_name%type
6524: )
6525: is
6526:
6527: cursor get_role(person_id per_all_people_f.person_id%TYPE)
6528: is
6529: select wf.name role_name
6530: from wf_roles wf
6531: where wf.orig_system = 'PER'

Line 6613: cursor get_supervisor_id(person_id per_all_people_f.person_id%TYPE)

6609: function get_manager_id ( p_person_id in per_all_assignments_f.person_id%type, p_assignment_id per_all_assignments_f.assignment_id%type)
6610: return number
6611: is
6612:
6613: cursor get_supervisor_id(person_id per_all_people_f.person_id%TYPE)
6614: is
6615: select supervisor_id from per_all_assignments_f
6616: where person_id=p_person_id
6617: and trunc(sysdate) between effective_start_date and effective_end_date