DBA Data[Home] [Help]

APPS.BEN_TEST_HARNESS dependencies on BEN_BATCH_ACTIONS

Line 1432: ben_batch_actions pba

1428: rbv.rollup_minesd,
1429: rbv.rollup_mineed,
1430: rbv.rollup_id_string
1431: from ben_rollup_rbv_summary rbv,
1432: ben_batch_actions pba
1433: where pba.batch_id = c_bft_id
1434: and rbv.batch_action_id = pba.batch_action_id
1435: and rbv.rollup_count > 0
1436: order by rbv.rollup_id;

Line 1480: from ben_batch_actions pba

1476: and nvl(bft.BENFTS_GRP_ID,-1) = nvl(c_bfg_id,-1)
1477: and bft.VALIDATE_FLAG = 'B'
1478: and exists
1479: (select 1
1480: from ben_batch_actions pba
1481: where pba.batch_id = bft.benefit_action_id
1482: )
1483: order by bft.benefit_action_id desc;
1484: --

Line 2343: ||' ben_batch_actions pba '

2339: ||' bft.opt_id, '
2340: ||' max(bft.creation_date) max_credt, '
2341: ||' max(bft.request_id) '
2342: ||' from ben_benefit_actions bft, '
2343: ||' ben_batch_actions pba '
2344: ||' '||l_where_str
2345: ||' group by bft.process_date, '
2346: ||' bft.mode_cd, '
2347: ||' bft.business_group_id, '