APPS.OKC_CG_UPD_ASMBLR_PVT SQL Statements

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

Line: 30

SELECT cg.counter_group_id counter_group_id,
       cg.source_object_code source_object_code,
       cg.source_object_id source_object_id
FROM   okx_counter_grp_log_v log,
       okx_counter_groups_v cg
WHERE  log.counter_group_id = cg.counter_group_id
AND    counter_grp_log_id  =  p_counter_grp_log_id;*/

Line: 37

SELECT ca.source_object_code source_object_code,
       ca.source_object_id source_object_id
       FROM   csi_counter_associations ca
       WHERE  ca.counter_id  = p_counter_id;

Line: 46

SELECT aae.element_name
FROM   okc_actions_b acn,
       okc_action_attributes_b aae
WHERE  acn.id = aae.acn_id
AND    acn.correlation = 'CTR_GRP_UPD' ;

Line: 54

SELECT dnz_chr_id k_id
FROM   okc_k_lines_b
WHERE  id = x;

Line: 60

select net_reading counter_reading
from csi_counter_readings
where counter_id = p_counter_id
and nvl(disabled_flag,'N') = 'N'
order by value_timestamp desc;