APPS.BIX_AGENT_CLASS_P dependencies on DUAL

Line 385: from dual;

381:
382:
383: BEGIN
384: select bix_util_pkg.get_null_lookup into l_unknown
385: from dual;
386: /*
387: SELECT meaning
388: into l_unknown
389: FROM fnd_lookups

Line 615: FROM dual;

611:
612: /* Fetch the sysdate */
613: SELECT sysdate
614: INTO g_sysdate
615: FROM dual;
616:
617:
618: g_idx :=0;
619: /* Get the User preferred time range (1/2 or 1 or 2 or 4 hour or 1 day) */

Line 623: FROM dual;

619: /* Get the User preferred time range (1/2 or 1 or 2 or 4 hour or 1 day) */
620: g_time_range := NULL;
621: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
622: INTO g_time_range
623: FROM dual;
624:
625: /* If there is no user prefered time range , set it to 1/2 hour */
626: IF g_time_range IS NULL THEN
627: g_time_range := 1;

Line 650: FROM dual;

646: /* "go" button in the paramter section */
647: IF (g_parent IS NOT NULL) THEN
648: SELECT TO_NUMBER(substr(g_parent, 2, decode(instr(g_parent,'c'), 0, length(g_parent), instr(g_parent,'c')-2)))
649: INTO v_group_id
650: FROM dual;
651: ELSIF (g_agent_group IS NOT NULL) THEN
652: v_group_id := g_agent_group;
653: ELSE
654: RETURN;

Line 661: FROM dual;

657: /* If the user has selected "All" for agent group paramter , display the default group of the user */
658: IF (v_group_id = -999) THEN
659: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
660: INTO v_group_id
661: FROM dual;
662: END IF;
663:
664:
665: