APPS.HXC_TIMEKEEPER_WF_PKG SQL Statements

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

Line: 13

  select hxc_approval_item_key_s.nextval
  Into l_item_key
  from dual;

Line: 30

      select asg.supervisor_id
        from per_all_assignments_f asg
       where asg.person_id = b_person_id
         and TRUNC(b_effective_date) between TRUNC(asg.effective_Start_date) and TRUNC(asg.effective_end_date)
         and asg.primary_flag = 'Y'
         and asg.assignment_type in ('E','C');

Line: 111

 select transaction_id
 from  hxc_transaction_details
 where time_building_block_id = p_tbb_id
 and   object_version_number  = p_tbb_ovn;

Line: 214

     cursor c_updated_by
         (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
         ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
         ) is
  select u.user_name
    from fnd_user u, hxc_time_building_blocks tbb
   where tbb.time_building_block_id = p_tc_id
     and tbb.object_version_number = p_tc_ovn
     and tbb.last_updated_by = u.user_id;

Line: 235

	      open c_updated_by(p_tc_bb_id,p_tc_bb_ovn);

Line: 236

              fetch c_updated_by into l_login;

Line: 238

              if (c_updated_by%NOTFOUND) then
                close c_updated_by;

Line: 245

              close c_updated_by;

Line: 260

SELECT ITEM_KEY,ITEM_TYPE
from wf_items
where parent_item_key =p_tk_audit_item_key
and parent_item_type = p_tk_audit_item_type;

Line: 269

   select Notification_id
    from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
    where WIAS.ITEM_TYPE = p_item_type
    and WIAS.ITEM_KEY = p_item_key
    and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
    and WPA.ACTIVITY_NAME = 'FYI_NOTIFICATION'
    and WPA.PROCESS_NAME = nvl('HXC_TK_AUDIT', WPA.PROCESS_NAME);

Line: 279

   select  wn.notification_id nid
   from  WF_NOTIFICATIONS WN, WF_ITEM_ACTIVITY_STATUSES WIAS
   where WN.GROUP_ID = WIAS.NOTIFICATION_ID
    and  WIAS.ITEM_TYPE = p_item_type
     and WIAS.ITEM_KEY = p_item_key;

Line: 374

select p.full_name from per_people_f p
where p.person_id=b_person_id
and b_effective_date between p.effective_start_date and p.effective_end_date;

Line: 380

            select full_name
              from per_all_people_f
             where person_id = b_person_id
             and  (effective_end_date=(select max(effective_end_date) from per_all_people_f
                where person_id=b_person_id and(effective_end_date<= b_effective_date)));

Line: 388

	select full_name
		from per_all_people_f
	        where person_id = b_person_id
	        and  (effective_start_date=(select min(effective_start_date) from per_all_people_f
				         where person_id=b_person_id and
					(effective_start_date>= b_effective_date)));

Line: 637

    SELECT tcsum.resource_id,
           tcsum.start_time,
           tcsum.stop_time
      FROM hxc_time_building_blocks tcsum
     WHERE  tcsum.time_building_block_id = p_tc_bbid
     AND    tcsum.object_version_number = p_tc_ovn ;

Line: 990

     cursor c_updated_by
         (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
         ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
         ) is
  select u.user_name
    from fnd_user u, hxc_time_building_blocks tbb
   where tbb.time_building_block_id = p_tc_id
     and tbb.object_version_number = p_tc_ovn
     and tbb.last_updated_by = u.user_id;

Line: 1189

PROCEDURE update_tk_ntf_result(
    p_itemtype in     varchar2,
    p_itemkey  in     varchar2,
    p_actid    in     number,
    p_funcmode in     varchar2,
    p_result   in out nocopy varchar2) IS

cursor c_transaction_id
(p_tbb_id  in number,
 p_tbb_ovn in number) is
 select transaction_id
 from  hxc_transaction_details
 where time_building_block_id = p_tbb_id
 and   object_version_number  = p_tbb_ovn;

Line: 1220

 select *
 from  hxc_errors
 where time_building_block_id = p_tbb_id
 and   time_building_block_ovn  = p_tbb_ovn
 and   message_name in ('HXC_WF_TK_WORKER_NO_RESPOND','HXC_WF_TK_SUPER_NO_RESPOND')
 and   (date_to=hr_general.end_of_time OR date_to is NULL);

Line: 1334

    wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.update_appl_period',
                    p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line: 1341

END UPDATE_TK_NTF_RESULT;