DBA Data[Home] [Help]

APPS.BEN_ROLLUP_RBVS dependencies on BEN_ROLLUP_RBV_SUMMARY

Line 4080: delete from ben_rollup_rbv_summary rlp

4076: --
4077: if nvl(p_refresh_rollups,'N') = 'Y'
4078: then
4079: --
4080: delete from ben_rollup_rbv_summary rlp
4081: where exists
4082: (select 1
4083: from ben_batch_actions bba
4084: where bba.batch_action_id = rlp.batch_action_id

Line 4250: insert into ben_rollup_rbv_summary

4246: --
4247: for va_en in l_batch_id_va.first ..l_batch_id_va.last
4248: loop
4249: --
4250: insert into ben_rollup_rbv_summary
4251: (rollup_id
4252: ,batch_action_id
4253: ,rollup_code
4254: ,rollup_count

Line 4263: (ben_rollup_rbv_summary_s.nextval

4259: ,rollup_date_string
4260: ,rollup_value_string
4261: )
4262: values
4263: (ben_rollup_rbv_summary_s.nextval
4264: ,l_batch_action_id
4265: ,l_class_code_va(va_en)
4266: ,l_class_code_count_va(va_en)
4267: ,l_class_sumovn_va(va_en)