APPS.BEN_ROLLUP_RBVS dependencies on BEN_BENEFIT_ACTIONS

Line 2409: ||' ben_benefit_actions bft, '

2405: --
2406: l_rt_cd_va(l_rt_en) := 'PERACTCCRRUN';
2407: l_rt_fromstr_va(l_rt_en) := ' from ben_person_actions pact, '
2408: ||' ben_batch_ranges bbr, '
2409: ||' ben_benefit_actions bft, '
2410: ||' fnd_concurrent_requests ccr '
2411: ;
2412: l_rt_wherestr_va(l_rt_en) := ' where pact.benefit_action_id = :benefit_action_id '
2413: ||' and pact.ACTION_STATUS_CD = '||''''||'U'||''''

Line 2462: ||' from ben_benefit_actions bft '

2458: l_rt_cd_va(l_rt_en) := 'WWBUGS';
2459: l_rt_fromstr_va(l_rt_en) := ' from ad_bugs abg ';
2460: l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
2461: ||' (select bft.last_update_date '
2462: ||' from ben_benefit_actions bft '
2463: ||' where bft.benefit_action_id = :benefit_action_id) ';
2464: --
2465: l_sel_str := ' select count(*) '
2466: ||', 0 sum_ovn '

Line 2485: ||' from ben_benefit_actions bft '

2481: l_rt_cd_va(l_rt_en) := 'WWBUGSBEN';
2482: l_rt_fromstr_va(l_rt_en) := ' from ad_bugs abg ';
2483: l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
2484: ||' (select bft.last_update_date '
2485: ||' from ben_benefit_actions bft '
2486: ||' where bft.benefit_action_id = :benefit_action_id) '
2487: ||' and abg.APPLICATION_SHORT_NAME = '||''''||'BEN'||'''';
2488: --
2489: l_rt_sqlstr_va(l_rt_en) := l_sel_str

Line 2504: ||' from ben_benefit_actions bft '

2500: l_rt_cd_va(l_rt_en) := 'WWBUGSPER';
2501: l_rt_fromstr_va(l_rt_en) := ' from ad_bugs abg ';
2502: l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
2503: ||' (select bft.last_update_date '
2504: ||' from ben_benefit_actions bft '
2505: ||' where bft.benefit_action_id = :benefit_action_id) '
2506: ||' and abg.APPLICATION_SHORT_NAME = '||''''||'PER'||'''';
2507: --
2508: l_rt_sqlstr_va(l_rt_en) := l_sel_str

Line 2523: ||' from ben_benefit_actions bft '

2519: l_rt_cd_va(l_rt_en) := 'WWBUGSPAY';
2520: l_rt_fromstr_va(l_rt_en) := ' from ad_bugs abg ';
2521: l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
2522: ||' (select bft.last_update_date '
2523: ||' from ben_benefit_actions bft '
2524: ||' where bft.benefit_action_id = :benefit_action_id) '
2525: ||' and abg.APPLICATION_SHORT_NAME = '||''''||'PAY'||'''';
2526: --
2527: l_rt_sqlstr_va(l_rt_en) := l_sel_str

Line 4027: from ben_benefit_actions bft

4023: (c_bft_id number
4024: )
4025: is
4026: select bft.validate_flag
4027: from ben_benefit_actions bft
4028: where bft.validate_flag in ('C','B')
4029: and bft.benefit_action_id = c_bft_id;
4030: --
4031: l_bft_dets c_bft_dets%rowtype;