APPS.HR_EX_EMPLOYEE_API dependencies on PER_BUSINESS_GROUPS

Line 630: l_legislation_code per_business_groups.legislation_code%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;
634: l_per_object_version_number per_assignments_f.object_version_number%TYPE;

Line 686: , per_business_groups bus

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
690: and bus.business_group_id = pds.business_group_id

Line 1887: l_legislation_code per_business_groups.legislation_code%TYPE;

1883: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1884: l_effective_start_date per_assignments_f.effective_start_date%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;

Line 1900: from per_business_groups bus

1896: , pds.actual_termination_date
1897: , pds.last_standard_process_date
1898: , pds.person_id
1899: , pds.object_version_number
1900: from per_business_groups bus
1901: , per_periods_of_service pds
1902: where pds.period_of_service_id = p_period_of_service_id
1903: and bus.business_group_id = pds.business_group_id;
1904: --