DBA Data[Home] [Help]

APPS.BEN_TEST_HARNESS dependencies on BEN_BATCH_RANGES

Line 1712: from ben_batch_ranges bbr,

1708: max(bbr.last_update_date) max_lud,
1709: count(*) cnt,
1710: round((max(bbr.last_update_date)-bft.creation_date)*(24*3600),2) tot_secs,
1711: round(((max(bbr.last_update_date)-bft.creation_date)*(24*3600))/count(*),2) avg_secs
1712: from ben_batch_ranges bbr,
1713: ben_benefit_actions bft
1714: where bbr.benefit_action_id = c_bft_id
1715: and bbr.benefit_action_id = bft.benefit_action_id
1716: group by bbr.last_update_login,

Line 1829: ben_batch_ranges bbr

1825: ,fnd_global.local_chr(13),' '),1,1000),
1826: count(*)
1827: from fnd_concurrent_requests ccr,
1828: ben_benefit_actions bft,
1829: ben_batch_ranges bbr
1830: where ccr.parent_request_id = bft.request_id
1831: and bbr.last_update_login = ccr.last_update_login
1832: and bft.benefit_action_id = bbr.benefit_action_id
1833: and bft.benefit_action_id = c_bft_id