APPS.GHR_SF52_VALIDN_PKG SQL Statements

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

Line: 88

 Procedure prelim_req_chk_for_update_hr
 (p_pa_request_rec             in      ghr_pa_requests%rowtype
 ) is

  l_proc              varchar2(72)    :=  g_package || 'primary_reqd_chk_for_update_hr';

Line: 102

    select pa_notification_id
    from   ghr_pa_requests par
    where  par.pa_request_id =  p_pa_request_rec.pa_request_id;

Line: 107

   Select ppt.system_person_type
   from   per_people_f per,
          per_person_types ppt
   where  per.person_id = p_pa_request_rec.person_id
   and    p_pa_request_rec.effective_date
   between per.effective_start_date and per.effective_end_date
   and    ppt.person_type_id = per.person_type_id;

Line: 215

End prelim_req_chk_for_update_hr;

Line: 240

      select  pos.business_group_id
      from    hr_all_positions_f pos
      where   pos.position_id = p_to_position_id
      and     p_effective_date between pos.effective_start_date and pos.effective_end_date;