APPS.BEN_BENMNGLE_PURGE dependencies on BEN_BENEFIT_ACTIONS

Line 33: rows in ben_benefit_actions.

29: 18-SEP-02 hmani 115.9 Bug# 2573240 modified
30: delete_reporting_rows procedure.
31: 26-DEC-02 rpillay 115.11 NOCOPY changes
32: 02-Aug-04 nhunur 115.12 3805304 - Added code to handle null request_id
33: rows in ben_benefit_actions.
34: 03-Dec-04 ikasire 115.13 Bug 4046914
35: 28-Dec-07 nhunur 115.14 Bug 6075014 - perf changes
36: */
37: --------------------------------------------------------------------------------

Line 423: delete from ben_benefit_actions

419: begin
420: --
421: hr_utility.set_location ('Entering '||l_package,10);
422: --
423: delete from ben_benefit_actions
424: where benefit_action_id = p_benefit_action_id;
425: --
426: p_rows := sql%rowcount;
427: --

Line 516: from ben_benefit_actions bft,

512: l_effective_date date;
513: --
514: cursor c_benefit_actions is
515: select bft.benefit_action_id
516: from ben_benefit_actions bft,
517: fnd_concurrent_requests fnd
518: where bft.business_group_id = nvl(p_business_group_id,bft.business_group_id)
519: and nvl(bft.request_id,-1) = nvl(p_concurrent_request_id,nvl(bft.request_id,-1))
520: and bft.process_date = nvl(l_effective_date,bft.process_date)