APPS.GHR_MASS_ACTIONS_PKG SQL Statements

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

Line: 23

	select  noa.nature_of_action_id, noa.description
	from    ghr_nature_of_actions noa
	where   noa.code = p_noa_code
	and     noa.enabled_flag = 'Y'
	and     nvl(p_effective_date,trunc(sysdate))
	between noa.date_from
	and     nvl(noa.date_to,nvl(p_effective_date,trunc(sysdate))) ;

Line: 67

   select   rem.remark_id,
            rem.description
   from     ghr_remarks  rem
   where    rem.code  =  p_remark_code
   and      rem.enabled_flag = 'Y'
   and      nvl(p_effective_date,sysdate)
   between  rem.date_from and nvl(rem.date_to,nvl(p_effective_date, trunc(sysdate)));

Line: 250

 procedure replace_insertion_values
(p_desc                in varchar2,
 p_information1        in varchar2 default null,
 p_information2        in varchar2 default null,
 p_information3        in varchar2 default null,
 p_information4        in varchar2 default null,
 p_information5        in varchar2 default null,
 p_desc_out            out nocopy varchar2
)
is

 -- assuming that this procedure would ever be called if there is an insertion value for the desc.

l_ins_count   number   := 0;

Line: 317

end replace_insertion_values;

Line: 337

    select  gbx.groupbox_id gpid, gbx.routing_group_id rgpid
    from    ghr_pois gpoi,
            ghr_groupboxes gbx,
            ghr_routing_groups rgp
    where   gbx.groupbox_id = gpoi.groupbox_id
    and     gpoi.personnel_office_id = l_personnel_office_id
    and     gbx.routing_group_id = rgp.routing_group_id;

Line: 346

    select count(*) cnt
    from   ghr_groupbox_users gbu
    where  gbu.groupbox_id  =  l_groupbox_id;

Line: 412

       SELECT person_id
       FROM   ghr_pois
       WHERE  personnel_office_id = c_personnel_office_id;