APPS.BEN_AGF_CACHE SQL Statements

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

Line: 45

select agf.age_fctr_id, agf.business_group_id
from ben_age_fctr agf
where exists
(select null
from ben_age_fctr agf
where
agf.age_fctr_id = agf.age_fctr_id)
order by agf.age_fctr_id;

Line: 55

select agf.age_fctr_id,
agf.mx_age_num,
agf.mn_age_num,
agf.no_mn_age_flag,
agf.no_mx_age_flag
from ben_age_fctr agf
order by agf.age_fctr_id
, agf.age_fctr_id;

Line: 202

g_cache_agf_lookup.delete;

Line: 203

g_cache_agf_inst.delete;