DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_API dependencies on PER_ALL_PEOPLE_F

Line 625: l_employee_number per_all_people_f.employee_number%TYPE;

621: l_dob_null_warning boolean;
622: l_effective_date date;
623: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
624: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
625: l_employee_number per_all_people_f.employee_number%TYPE;
626: l_applicant_number per_people_f.applicant_number%TYPE;
627: l_npw_number per_people_f.npw_number%TYPE;
628: l_exists varchar2(1);
629: l_full_name per_all_people_f.full_name%TYPE;

Line 629: l_full_name per_all_people_f.full_name%TYPE;

625: l_employee_number per_all_people_f.employee_number%TYPE;
626: l_applicant_number per_people_f.applicant_number%TYPE;
627: l_npw_number per_people_f.npw_number%TYPE;
628: l_exists varchar2(1);
629: l_full_name per_all_people_f.full_name%TYPE;
630: l_legislation_code per_business_groups.legislation_code%TYPE;
631: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;
632: l_name_combination_warning boolean;
633: l_orig_hire_warning boolean;

Line 636: l_person_id per_all_people_f.person_id%TYPE;

632: l_name_combination_warning boolean;
633: l_orig_hire_warning boolean;
634: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
635: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
636: l_person_id per_all_people_f.person_id%TYPE;
637: l_person_type_id per_all_people_f.person_type_id%TYPE;
638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
639: l_proc varchar2(72)
640: := g_package || 'actual_termination_emp';

Line 637: l_person_type_id per_all_people_f.person_type_id%TYPE;

633: l_orig_hire_warning boolean;
634: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
635: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
636: l_person_id per_all_people_f.person_id%TYPE;
637: l_person_type_id per_all_people_f.person_type_id%TYPE;
638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
639: l_proc varchar2(72)
640: := g_package || 'actual_termination_emp';
641: l_system_person_type per_person_types.system_person_type%TYPE;

Line 638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;

634: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
635: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
636: l_person_id per_all_people_f.person_id%TYPE;
637: l_person_type_id per_all_people_f.person_type_id%TYPE;
638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
639: l_proc varchar2(72)
640: := g_package || 'actual_termination_emp';
641: l_system_person_type per_person_types.system_person_type%TYPE;
642: l_system_person_type1 per_person_types.system_person_type%TYPE;

Line 661: from per_all_people_f per

657: --
658:
659: cursor csr_future_per_changes is
660: select null
661: from per_all_people_f per
662: where per.person_id = l_person_id
663: and per.effective_start_date > l_actual_termination_date;
664: --
665: cursor csr_get_asgs_to_terminate is

Line 685: from per_all_people_f per

681: , pet.system_person_type
682: , per.npw_number
683: , pds.actual_termination_date
684: , pds.last_standard_process_date
685: from per_all_people_f per
686: , per_business_groups bus
687: , per_periods_of_service pds
688: , per_person_types pet
689: where pds.period_of_service_id = p_period_of_service_id

Line 711: from per_all_people_f

707: --
708: --
709: cursor csr_date_of_death is
710: select date_of_death
711: from per_all_people_f
712: where person_id = l_person_id;
713: --
714: -- Fix for bug 3829474 starts here.
715: --

Line 1165: -- per_all_people_f

1161: hr_utility.raise_error;
1162: end if;
1163: --
1164: -- PTU changes: must maintain default of correct "ex-emp" type on
1165: -- per_all_people_f
1166: --
1167: if l_system_person_type = 'EMP' then
1168: l_system_person_type1 := 'EX_EMP';
1169: elsif l_system_person_type = 'EMP_APL' then

Line 1889: l_person_id per_all_people_f.person_id%TYPE;

1885: l_exists varchar2(1);
1886: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
1887: l_legislation_code per_business_groups.legislation_code%TYPE;
1888: l_object_version_number per_periods_of_service.object_version_number%TYPE;
1889: l_person_id per_all_people_f.person_id%TYPE;
1890: l_proc varchar2(72) := g_package || 'final_process_emp';
1891: l_exemppet_eff_date date;
1892: l_action_chk VARCHAR2(1) := 'N';
1893: --

Line 1923: from per_all_people_f per

1919: order by asg.primary_flag;
1920: --
1921: cursor csr_valid_ex_emp is
1922: select null
1923: from per_all_people_f per
1924: , per_person_type_usages_f ptu
1925: , per_person_types pet
1926: where per.person_id = l_person_id
1927: and l_exemppet_eff_date between per.effective_start_date