APPS.HR_EX_EMPLOYEE_API dependencies on PER_BUSINESS_GROUPS

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

Line 744: , per_business_groups bus

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

Line 2178: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 2191: from per_business_groups bus

2187: , pds.actual_termination_date
2188: , pds.last_standard_process_date
2189: , pds.person_id
2190: , pds.object_version_number
2191: from per_business_groups bus
2192: , per_periods_of_service pds
2193: where pds.period_of_service_id = p_period_of_service_id
2194: and bus.business_group_id = pds.business_group_id;
2195: --