APPS.BEN_LOS_CACHE SQL Statements

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

Line: 45

select los.los_fctr_id, los.business_group_id
from ben_los_fctr los
where exists
(select null
from ben_los_fctr los
where
los.los_fctr_id = los.los_fctr_id)
order by los.los_fctr_id;

Line: 55

select los.los_fctr_id,
los.mx_los_num,
los.mn_los_num,
los.no_mn_los_num_apls_flag,
los.no_mx_los_num_apls_flag
from ben_los_fctr los
order by los.los_fctr_id
, los.los_fctr_id;

Line: 202

g_cache_los_lookup.delete;

Line: 203

g_cache_los_inst.delete;