APPS.BIX_CALLS_HANDLED_RPT_PKG dependencies on DUAL

Line 489: FROM dual;

485:
486: /* Get the ICX Session Id */
487: SELECT icx_sec.g_session_id
488: INTO g_session_id
489: FROM dual;
490:
491: /* Delete the rows from the table bix_dm_report for the current icx session and report */
492: /* so that we donot display the leftover rows from the previous execution of the report */
493: DELETE bix_dm_report

Line 500: FROM dual;

496:
497: /* Fetch the sysdate */
498: SELECT sysdate
499: INTO g_sysdate
500: FROM dual;
501:
502: /* Get the User preferred time range (1/2 or 1 or 2 or 4 hour or 1 day) */
503: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
504: INTO g_time_range

Line 505: FROM dual;

501:
502: /* Get the User preferred time range (1/2 or 1 or 2 or 4 hour or 1 day) */
503: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
504: INTO g_time_range
505: FROM dual;
506:
507: /* If there is no user prefered time range , set it to 1/2 hour */
508: IF g_time_range IS NULL THEN
509: g_time_range := 1;

Line 527: FROM dual;

523: /* g_agent_group = "not null" : User has navigated to the report from the parameter page */
524: IF (g_parent IS NOT NULL) THEN
525: SELECT TO_NUMBER(substr(g_parent, 2, decode(instr(g_parent,'c'), 0, length(g_parent), instr(g_parent,'c')-2)))
526: INTO l_group_id
527: FROM dual;
528: ELSIF (g_agent_group IS NOT NULL) THEN
529: l_group_id := TO_NUMBER(g_agent_group);
530: ELSE
531: RETURN;

Line 538: FROM dual;

534: /* If the user has selected "All" for agent group paramter , display the default group of the user */
535: IF (l_group_id = -999) THEN
536: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
537: INTO l_group_id
538: FROM dual;
539: END IF;
540:
541: /* l_group_id = "null" : user has selected "All" as agent group paramter */
542: /* and (s)he is not assigned to any default group */