The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MAX(tbb.object_version_number)
FROM hxc_time_building_blocks tbb
WHERE tbb.time_building_block_id = p_bb_id;
SELECT htd.time_building_block_id,
htd.time_building_block_ovn,
ht.transaction_process_id
FROM hxc_transaction_details htd,
hxc_transactions ht,
hxc_retrieval_processes hrp
WHERE htd.time_building_block_id = p_curr_bb_id
AND htd.transaction_id = ht.transaction_id
AND ht.type = 'RETRIEVAL'
AND htd.status = 'SUCCESS'
AND ht.transaction_process_id IN (-1,hrp.retrieval_process_id)
AND hrp.name = 'BEE Retrieval Process'
ORDER BY 2 DESC ;
INSERT INTO hxc_bee_pref_adj_lines
( timecard_id,
timecard_ovn,
resource_id,
detail_bb_id,
detail_bb_ovn,
date_earned,
batch_source
)
VALUES ( p_tc_id,
p_tc_ovn,
p_resource_id,
l_tbb_id,
l_tbb_ovn,
p_date_earned,
l_batch_source
);
l_period_tab.DELETE;
SELECT
rrc.time_recipient_id
, rrc.status
FROM
hxc_retrieval_rule_comps rrc
, hxc_retrieval_rules rr
, hxc_retrieval_rule_grp_comps_v rrgc
, hxc_retrieval_rule_groups_v rrg
WHERE
rrg.retrieval_rule_group_id = p_rtr_grp_id
AND
rrgc.retrieval_rule_group_id = rrg.retrieval_rule_group_id AND
rrgc.retrieval_process_id = p_process_id
AND
rr.retrieval_rule_id = rrgc.retrieval_rule_id
AND
rrc.retrieval_rule_id = rr.retrieval_rule_id;
SELECT last_name
FROM per_people_f
WHERE person_id = p_resource_id;
SELECT 1
FROM hxc_application_set_comps_v apsc
, hxc_application_sets_v aps
WHERE aps.application_set_id = p_app_set_id
AND
apsc.application_set_id = aps.application_set_id AND
apsc.time_recipient_id = p_ret_tr_id;
SELECT ret.retrieval_process_id
FROM hxc_retrieval_processes ret
WHERE ret.name = 'BEE Retrieval Process';
--delete the ret ranges table. This is because we maintain ret ranges table for each resource
l_ret_ranges.delete;
l_tmp_otm_tab.DELETE;
l_tmp_rtr_tab.DELETE;
l_ret_ranges1.delete;
l_ret_ranges_tmp_tab.delete;
l_resource_rtr.DELETE;
l_resource_rrg_id_tab.DELETE;
l_resource_rrg_id_tab.DELETE(l_rtr_grp_id);
, p_bb_deleted VARCHAR2
, p_bb_start_time DATE
, p_bb_stop_time DATE
, p_bb_id NUMBER -- 6121705
, p_bb_ovn NUMBER -- 6121705
, p_attribute_category VARCHAR2 -- Absences Integration -- 8779478
, p_process VARCHAR2 -- 6121705
, p_prefs t_pref
, p_ret_rules t_ret_rule
, p_rtr_outcomes t_rtr_outcome
, p_tc_bb_id NUMBER
, p_tc_bb_ovn NUMBER
, p_timecard_retrieve IN OUT NOCOPY BOOLEAN
, p_day_retrieve IN OUT NOCOPY BOOLEAN
, p_tc_locked IN OUT NOCOPY BOOLEAN
, p_tc_first_lock IN OUT NOCOPY BOOLEAN
, p_bb_skipped_reason OUT NOCOPY VARCHAR2) IS
l_outcome_start PLS_INTEGER;
IF ( p_prefs(p_resource_id).prefs_ok = 'Y' AND p_bb_deleted = 'N' )
THEN
l_rtr_start := p_prefs(p_resource_id).rtr_start;
l_rtr_grp.DELETE(p_ret_rules(rtr_cnt).rtr_grp_id);
l_rtr_grp.DELETE;
l_rtr_grp.DELETE;
ELSIF ( p_prefs(p_resource_id).prefs_ok = 'Y' AND p_bb_deleted = 'Y' )
THEN
p_day_retrieve := TRUE;
'N', -- Bug 8366309 'N' is an UPDATE or NEW entry; DELETED = 'N'
l_day_table.DELETE;
SELECT transaction_id
, TRUNC(transaction_date) transaction_date
FROM hxc_transactions tx
WHERE tx.transaction_process_id = p_process_id
AND tx.type = 'RETRIEVAL'
AND tx.status = 'IN PROGRESS'
AND tx.transaction_date < p_conc_date
FOR UPDATE OF status NOWAIT;
SELECT MIN(cr.actual_start_date)
FROM
fnd_concurrent_programs cp
, fnd_concurrent_requests cr
WHERE
cp.concurrent_program_name = p_conc_program_name AND
cp.application_id = p_app_id
AND
cr.concurrent_program_id = cp.concurrent_program_id AND
cr.status_code = 'R';
SELECT a.application_id
FROM fnd_application a
WHERE a.application_short_name = p_appl_short_name;
-- we have some rogue transactions - let's update them
l_index := l_tx_tab.FIRST;
UPDATE hxc_transactions tx
SET tx.status = 'RECOVERED'
WHERE tx.transaction_id = l_index;
-- been updated in SQL. 99.9% of the time the transaction will
-- exist thus the table will be locked
UPDATE hxc_retrieval_ranges rr
SET rr.transaction_id = -999
WHERE rr.creation_date < l_req_date
AND rr.retrieval_process_id = p_process_id
AND rr.transaction_id = 0;
SELECT cr.status_code
FROM fnd_concurrent_requests cr
WHERE cr.request_id = p_conc_request_id;
select 1
from per_all_assignments_f paa, hr_soft_coding_keyflex hsk
where paa.person_id = rrr.resource_id
and paa.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
and hsk.segment1 = :p_gre_id
';
select 1
from per_all_assignments_f paa
where paa.person_id = rrr.resource_id
';
SELECT count(*) INTO l_exists
FROM hxc_absence_type_elements
WHERE element_type_id = p_element_type_id
AND rownum < 2;