APPS.HR_EX_EMPLOYEE_API dependencies on PER_ALL_PEOPLE_F

Line 648: l_employee_number per_all_people_f.employee_number%TYPE;

644: l_dob_null_warning boolean;
645: l_effective_date date;
646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);
652: l_full_name per_all_people_f.full_name%TYPE;

Line 652: l_full_name per_all_people_f.full_name%TYPE;

648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);
652: l_full_name per_all_people_f.full_name%TYPE;
653: l_legislation_code per_business_groups.legislation_code%TYPE;
654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;
655: l_name_combination_warning boolean;
656: l_orig_hire_warning boolean;

Line 659: l_person_id per_all_people_f.person_id%TYPE;

655: l_name_combination_warning boolean;
656: l_orig_hire_warning boolean;
657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
659: l_person_id per_all_people_f.person_id%TYPE;
660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';

Line 660: l_person_type_id per_all_people_f.person_type_id%TYPE;

656: l_orig_hire_warning boolean;
657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
659: l_person_id per_all_people_f.person_id%TYPE;
660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';
664: l_system_person_type per_person_types.system_person_type%TYPE;

Line 661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;

657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
659: l_person_id per_all_people_f.person_id%TYPE;
660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';
664: l_system_person_type per_person_types.system_person_type%TYPE;
665: l_system_person_type1 per_person_types.system_person_type%TYPE;

Line 686: from per_all_people_f per

682:
683:
684: cursor csr_future_per_changes is
685: select null
686: from per_all_people_f per
687: where per.person_id = l_person_id
688: and per.effective_start_date > l_actual_termination_date;
689:
690: -- ER FPT

Line 706: from per_all_people_f per, per_person_types ppt

702:
703: cursor fut_person_rec is
704: select per.person_type_id, per.object_version_number, per.effective_start_date
705: ,per.applicant_number, per.employee_number, per.npw_number
706: from per_all_people_f per, per_person_types ppt
707: where per.person_id = l_person_id
708: and per.effective_start_date > l_actual_termination_date + 1
709: and per.person_type_id = ppt.person_type_id
710: and ppt.system_person_type in ('EMP','EMP_APL');

Line 714: from per_all_people_f

710: and ppt.system_person_type in ('EMP','EMP_APL');
711:
712: cursor min_start_date is
713: select effective_start_date, person_type_id
714: from per_all_people_f
715: where person_id = l_person_id
716: and effective_start_date =
717: (select min(effective_start_date)
718: from per_all_people_f

Line 718: from per_all_people_f

714: from per_all_people_f
715: where person_id = l_person_id
716: and effective_start_date =
717: (select min(effective_start_date)
718: from per_all_people_f
719: where person_id = l_person_id
720: and effective_start_date > l_actual_termination_date);
721: -- ER FPT
722: --

Line 743: from per_all_people_f per

739: , pet.system_person_type
740: , per.npw_number
741: , pds.actual_termination_date
742: , pds.last_standard_process_date
743: from per_all_people_f per
744: , per_business_groups bus
745: , per_periods_of_service pds
746: , per_person_types pet
747: where pds.period_of_service_id = p_period_of_service_id

Line 769: from per_all_people_f

765: --
766: --
767: cursor csr_date_of_death is
768: select date_of_death
769: from per_all_people_f
770: where person_id = l_person_id;
771: --
772: -- Fix for bug 3829474 starts here.
773: --

Line 1354: -- per_all_people_f

1350: hr_utility.raise_error;
1351: end if;
1352: --
1353: -- PTU changes: must maintain default of correct "ex-emp" type on
1354: -- per_all_people_f
1355: --
1356: if l_system_person_type = 'EMP' then
1357: l_system_person_type1 := 'EX_EMP';
1358: elsif l_system_person_type = 'EMP_APL' then

Line 2180: l_person_id per_all_people_f.person_id%TYPE;

2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;
2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;
2180: l_person_id per_all_people_f.person_id%TYPE;
2181: l_proc varchar2(72) := g_package || 'final_process_emp';
2182: l_exemppet_eff_date date;
2183: l_action_chk VARCHAR2(1) := 'N';
2184: --

Line 2214: from per_all_people_f per

2210: order by asg.primary_flag;
2211: --
2212: cursor csr_valid_ex_emp is
2213: select null
2214: from per_all_people_f per
2215: , per_person_type_usages_f ptu
2216: , per_person_types pet
2217: where per.person_id = l_person_id
2218: and l_exemppet_eff_date between per.effective_start_date