APPS.BEN_ROLLUP_RBVS dependencies on BEN_BATCH_ACTIONS

Line 4038: from ben_batch_actions bat

4034: (c_bft_id number
4035: )
4036: is
4037: select bat.batch_id
4038: from ben_batch_actions bat
4039: where bat.batch_id = c_bft_id;
4040: --
4041: l_rubft_dets c_rubft_dets%rowtype;
4042: --

Line 4083: from ben_batch_actions bba

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
4085: and bba.batch_id = p_benefit_action_id
4086: );
4087: --

Line 4088: delete from ben_batch_actions bba

4084: where bba.batch_action_id = rlp.batch_action_id
4085: and bba.batch_id = p_benefit_action_id
4086: );
4087: --
4088: delete from ben_batch_actions bba
4089: where bba.batch_id = p_benefit_action_id;
4090: --
4091: end if;
4092: --

Line 4229: insert into ben_batch_actions

4225: then
4226: --
4227: -- Insert a batch action
4228: --
4229: insert into ben_batch_actions
4230: (batch_action_id
4231: ,batch_id
4232: ,batch_type
4233: ,rollup_count

Line 4237: (ben_batch_actions_s.nextval

4233: ,rollup_count
4234: ,rollup_sumovn
4235: )
4236: values
4237: (ben_batch_actions_s.nextval
4238: ,p_benefit_action_id
4239: ,'BEN_BFT'
4240: ,l_rollupcnt_tot
4241: ,l_rollupsumovn_tot