APPS.HR_NZ_ASSIGNMENT_LEG_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

	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.';

Line: 53

     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';

Line: 85

     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';