eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CONTINGENT_WORKER_API dependencies on PER_BUSINESS_GROUPS

Line 1717: l_legislation_code per_business_groups.legislation_code%TYPE;

1713: l_effective_start_date date;
1714: l_npw_number per_people_f.npw_number%TYPE;
1715: l_exists varchar2(1);
1716: l_full_name per_all_people_f.full_name%TYPE;
1717: l_legislation_code per_business_groups.legislation_code%TYPE;
1718: l_max_tpe_end_date date;
1719: l_name_combination_warning boolean;
1720: l_orig_hire_warning boolean;
1721: l_per_object_version_number number;

Line 1772: , per_business_groups bus

1768: , per.object_version_number
1769: , per.npw_number
1770: , per.applicant_number
1771: from per_all_people_f per
1772: , per_business_groups bus
1773: , per_periods_of_placement pdp
1774: where pdp.person_id = p_person_id
1775: and pdp.date_start = p_date_start
1776: and bus.business_group_id = pdp.business_group_id

Line 2334: l_legislation_code per_business_groups.legislation_code%TYPE;

2330: l_effective_end_date date;
2331: l_effective_start_date date;
2332: l_exists varchar2(1);
2333: l_last_standard_process_date date;
2334: l_legislation_code per_business_groups.legislation_code%TYPE;
2335: l_object_version_number number;
2336: l_person_id number;
2337: l_proc varchar2(72) := g_package ||
2338: 'final_process_placement';

Line 2347: from per_business_groups bus

2343: , pdp.actual_termination_date
2344: , pdp.last_standard_process_date
2345: , pdp.person_id
2346: , pdp.object_version_number
2347: from per_business_groups bus
2348: , per_periods_of_placement pdp
2349: where pdp.person_id = p_person_id
2350: and pdp.date_start = p_date_start
2351: and bus.business_group_id = pdp.business_group_id;