The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hxc_approval_item_key_s.nextval
Into l_item_key
from dual;
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');
select transaction_id
from hxc_transaction_details
where time_building_block_id = p_tbb_id
and object_version_number = p_tbb_ovn;
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;
open c_updated_by(p_tc_bb_id,p_tc_bb_ovn);
fetch c_updated_by into l_login;
if (c_updated_by%NOTFOUND) then
close c_updated_by;
close c_updated_by;
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;
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);
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;
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;
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)));
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)));
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 ;
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;
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;
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);
wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.update_appl_period',
p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
END UPDATE_TK_NTF_RESULT;