APPS.HR_CONTINGENT_WORKER_API dependencies on PER_BUSINESS_GROUPS

Line 2090: l_legislation_code per_business_groups.legislation_code%TYPE;

2086: l_effective_start_date date;
2087: l_npw_number per_people_f.npw_number%TYPE;
2088: l_exists varchar2(1);
2089: l_full_name per_all_people_f.full_name%TYPE;
2090: l_legislation_code per_business_groups.legislation_code%TYPE;
2091: l_max_tpe_end_date date;
2092: l_name_combination_warning boolean;
2093: l_orig_hire_warning boolean;
2094: l_per_object_version_number number;

Line 2145: , per_business_groups bus

2141: , per.object_version_number
2142: , per.npw_number
2143: , per.applicant_number
2144: from per_all_people_f per
2145: , per_business_groups bus
2146: , per_periods_of_placement pdp
2147: where pdp.person_id = p_person_id
2148: and pdp.date_start = p_date_start
2149: and bus.business_group_id = pdp.business_group_id

Line 2755: l_legislation_code per_business_groups.legislation_code%TYPE;

2751: l_effective_end_date date;
2752: l_effective_start_date date;
2753: l_exists varchar2(1);
2754: l_last_standard_process_date date;
2755: l_legislation_code per_business_groups.legislation_code%TYPE;
2756: l_object_version_number number;
2757: l_person_id number;
2758: l_proc varchar2(72) := g_package ||
2759: 'final_process_placement';

Line 2768: from per_business_groups bus

2764: , pdp.actual_termination_date
2765: , pdp.last_standard_process_date
2766: , pdp.person_id
2767: , pdp.object_version_number
2768: from per_business_groups bus
2769: , per_periods_of_placement pdp
2770: where pdp.person_id = p_person_id
2771: and pdp.date_start = p_date_start
2772: and bus.business_group_id = pdp.business_group_id;