APPS.HR_BPL_ALERT_RECIPIENT dependencies on PER_ALL_PEOPLE_F

Line 160: FROM per_all_people_f psn

156: ,psn.person_id
157: ,psn.full_name
158: ,psn.correspondence_language
159: ,psn.business_group_id
160: FROM per_all_people_f psn
161: ,per_all_assignments_f asg
162: ,per_all_assignments_f asg2
163: ,per_assignment_status_types ast
164: ,per_assignment_status_types ast2

Line 324: FROM per_all_people_f psn

320: ,psn.person_id
321: ,psn.full_name
322: ,psn.correspondence_language
323: ,psn.business_group_id
324: FROM per_all_people_f psn
325: ,per_all_assignments_f asg
326: ,per_assignment_status_types ast
327: WHERE asg.assignment_id = cp_assignment_id
328: AND asg.supervisor_id = psn.person_id

Line 469: FROM per_all_people_f psn

465: ,psn.person_id
466: ,psn.full_name
467: ,psn.correspondence_language
468: ,psn.business_group_id
469: FROM per_all_people_f psn
470: ,per_all_assignments_f asg
471: ,per_assignment_status_types ast
472: WHERE asg.assignment_id = cp_assignment_id
473: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 607: FROM per_all_people_f psn

603: ,DECODE(email_address,NULL,-1,p_person_id)
604: ,full_name
605: ,correspondence_language
606: ,business_group_id
607: FROM per_all_people_f psn
608: WHERE person_id = cp_person_id
609: AND ((psn.current_employee_flag = 'Y') OR
610: (psn.current_npw_flag = 'Y'))
611: AND (

Line 617: FROM per_all_people_f psn2

613: AND psn.effective_end_date)
614: OR
615: (
616: (NOT EXISTS (SELECT 'X'
617: FROM per_all_people_f psn2
618: WHERE psn2.person_id = psn.person_id
619: AND ((psn2.current_employee_flag = 'Y') OR
620: (psn2.current_npw_flag = 'Y'))
621: AND TRUNC(SYSDATE) BETWEEN psn2.effective_start_date

Line 627: FROM per_all_people_f psn3

623: AND
624: (psn.effective_start_date IN
625: (
626: SELECT MIN(psn3.effective_start_date)
627: FROM per_all_people_f psn3
628: WHERE psn3.person_id = psn.person_id
629: AND ((psn3.current_employee_flag = 'Y') OR
630: (psn3.current_npw_flag = 'Y'))
631: AND psn3.effective_start_date > TRUNC(SYSDATE)

Line 730: FROM per_all_people_f psn

726: ,DECODE(email_address,NULL,-1,p_person_id)
727: ,full_name
728: ,correspondence_language
729: ,business_group_id
730: FROM per_all_people_f psn
731: WHERE person_id = cp_person_id
732: --AND ((psn.current_employee_flag = 'Y') OR
733: -- (psn.current_npw_flag = 'Y'))
734: AND (

Line 740: FROM per_all_people_f psn2

736: AND psn.effective_end_date)
737: OR
738: (
739: (NOT EXISTS (SELECT 'X'
740: FROM per_all_people_f psn2
741: WHERE psn2.person_id = psn.person_id
742: AND ((psn2.current_employee_flag = 'Y') OR
743: (psn2.current_npw_flag = 'Y'))
744: AND TRUNC(SYSDATE) BETWEEN psn2.effective_start_date

Line 750: FROM per_all_people_f psn3

746: AND
747: (psn.effective_start_date IN
748: (
749: SELECT MIN(psn3.effective_start_date)
750: FROM per_all_people_f psn3
751: WHERE psn3.person_id = psn.person_id
752: AND ((psn3.current_employee_flag = 'Y') OR
753: (psn3.current_npw_flag = 'Y'))
754: AND psn3.effective_start_date > TRUNC(SYSDATE)

Line 884: -- Get details from the per_all_people_f for the primary

880: END Get_psn_eml_addrss;
881: --
882: -- -----------------------------------------------------------------------------
883: --
884: -- Get details from the per_all_people_f for the primary
885: -- assignment supervisor for a given person_id
886: --
887: PROCEDURE cache_psn_sup_psn_details(p_person_id IN NUMBER)
888: IS

Line 899: FROM per_all_people_f psn

895: ,psn.person_id
896: ,psn.full_name
897: ,psn.correspondence_language
898: ,psn.business_group_id
899: FROM per_all_people_f psn
900: ,per_all_assignments_f asg
901: WHERE asg.person_id = cp_person_id
902: AND asg.primary_flag = 'Y'
903: AND asg.supervisor_id = psn.person_id