APPS.GHR_SF52_POST_UPDATE SQL Statements

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

Line: 35

   select ghr_pa_notifications_s.nextval from sys.dual;

Line: 139

,p_action_taken			=>   'UPDATE_HR_COMPLETE'
,p_par_object_version_number	=>   l_object_version_number
);

Line: 184

   select ghr_pa_notifications_s.nextval from sys.dual;

Line: 187

    select par.person_id,
           par.employee_assignment_id
    from   ghr_pa_requests par
    where  par.pa_request_id = p_pa_request_id;

Line: 194

   select  asg1.assignment_id
   from    per_all_assignments_f asg1,
           per_all_assignments_f asg
   where   asg.person_id   = l_person_id
   and     asg1.person_id <> l_person_id
   and     p_effective_date
   between asg.effective_start_date  and asg.effective_end_date
   and     asg.assignment_type NOT IN ('A','B')
   and     asg1.assignment_type NOT IN ('A','B')
   and     asg1.position_id   = asg.position_id
   and     asg1.effective_start_date
   between asg.effective_start_date and asg.effective_end_date;

Line: 252

,p_action_taken			=>   'UPDATE_HR_COMPLETE'
,p_par_object_version_number	=>   l_object_version_number
);

Line: 330

  select pos.business_group_id
  from   hr_all_positions_f pos  -- Venkat
  where  pos.position_id = p_position_id
  and   p_effective_date between pos.effective_start_date and
                  pos.effective_end_date;

Line: 337

   select  par.noa_family_code,
           par.altered_pa_request_id,
	   par.second_noa_code                        --  Bug 3451929
   from    ghr_pa_requests par
   where   par.pa_request_id = p_pa_request_id;

Line: 344

   select  	par.noa_family_code,
		par.first_noa_code,
		par.second_noa_code
   from 	ghr_pa_requests par
   where	par.pa_request_id = p_pa_request_id;

Line: 351

   select	parei.rei_information4,
                parei.rei_information5,                 -- Bug 3547836
		parei.rei_information6,                 -- Bug 3547836
		parei.rei_information10
   from	ghr_pa_request_extra_info parei
   where	parei.pa_request_id = p_pa_request_id
	and	parei.information_type = p_information_type;

Line: 360

   select par.from_agency_code,
          par.from_agency_desc,
          par.agency_code,
          par.employee_dept_or_agency,
          par.from_office_symbol,
          par.to_office_symbol,
          par.personnel_office_id
   from   ghr_pa_requests par
   where  par.pa_request_id = l_altered_pa_request_id;

Line: 569

end ghr_sf52_post_update;