The following lines contain the word 'select', 'insert', 'update' or 'delete':
been shipped to customers. Explicit update or delete API
calls will need to be added to the end of the script.
Change List
-----------
Version Date Author ER/CR No. Description of Change
-------+---------+-----------+---------+--------------------------
110.0 25-Jun-99 P.Macdonald Created
================================================================= */
--
-- Package Variables
--
g_package VARCHAR2(33) := 'hr_nz_assignment_leg_hook.';
SELECT paf.business_group_id
FROM per_assignments_f paf
,per_business_groups pbg
WHERE paf.assignment_id = c_assignment_id
AND paf.business_group_id = pbg.business_group_id
AND c_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND pbg.legislation_code = 'NZ';
SELECT ppf.business_group_id
FROM per_people_f ppf
,per_business_groups pbg
WHERE ppf.person_id = c_person_id
AND ppf.business_group_id = pbg.business_group_id
AND c_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND pbg.legislation_code = 'NZ';