DBA Data[Home] [Help]

APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on DUAL

Line 16: FROM dual;

12:
13: /* Get the ICX Session Id */
14: SELECT icx_sec.g_session_id
15: INTO l_session_id
16: FROM dual;
17:
18: /* Delete the rows from table bix_dm_bin for the current icx session and bin */
19: DELETE bix_dm_bin
20: WHERE bin_code = 'BIX_CALLS_HANDLED_BIN'

Line 26: FROM dual;

22:
23: /* Get the default Agent Group of the Agent executing the report */
24: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
25: INTO l_default_group_id
26: FROM dual;
27:
28: /* If the user has not setup his/her default group fetch any one group */
29: /* to which the user belongs and report on that group; if the user does */
30: /* not belong to any group then do not show any data in the bin */