DBA Data[Home] [Help]

APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on BIX_UTIL_PKG

Line 68: , bix_util_pkg.get_hrmiss_frmt(trunc(SUM(bac.in_talk_time + bac.out_talk_time + bac.in_wrap_time +

64: , 'p' || to_char(l_default_group_id)
65: , rsc.source_name
66: , SUM(bac.in_calls_handled)
67: , SUM(bac.out_calls_handled)
68: , bix_util_pkg.get_hrmiss_frmt(trunc(SUM(bac.in_talk_time + bac.out_talk_time + bac.in_wrap_time +
69: bac.out_wrap_time) / DECODE(SUM(bac.in_calls_handled + bac.out_calls_handled),
70: 0, 1, SUM(bac.in_calls_handled + bac.out_calls_handled))))
71: FROM bix_dm_agent_call_sum bac
72: , jtf_rs_group_members mem

Line 97: , bix_util_pkg.get_hrmiss_frmt(trunc(SUM(bgc.in_talk_time + bgc.out_talk_time + bgc.in_wrap_time +

93: , 'p' || to_char(grp.group_id)
94: , grp.group_name
95: , SUM(bgc.in_calls_handled)
96: , SUM(bgc.out_calls_handled)
97: , bix_util_pkg.get_hrmiss_frmt(trunc(SUM(bgc.in_talk_time + bgc.out_talk_time + bgc.in_wrap_time +
98: bgc.out_wrap_time) / DECODE(SUM(bgc.in_calls_handled + bgc.out_calls_handled), 0, 1,
99: SUM(bgc.in_calls_handled + bgc.out_calls_handled))))
100: FROM
101: bix_dm_group_call_sum bgc