APPS.BIX_REAL_TIME_RPTS_PKG dependencies on DUAL

Line 112: FROM dual;

108: of the user */
109: IF (v_group_id = -999) THEN
110: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
111: INTO v_group_id
112: FROM dual;
113: END IF;
114:
115: /* or the user has selected "all" as agent group paramter and (s)he is not assigned to
116: any default group */

Line 462: select bix_util_pkg.get_null_lookup into l_string2 from dual;

458:
459: /*
460: numRowRTmeasure := 6;
461: i :=0;
462: select bix_util_pkg.get_null_lookup into l_string2 from dual;
463: for rec in getCallsWaitingForClass loop
464: if rec.class is null then l_string:= l_string2;
465: else l_string :=rec.class;
466: end if;

Line 1283: from dual;

1279: end if;
1280:
1281:
1282: select bix_util_pkg.get_null_lookup into l_unknown
1283: from dual;
1284:
1285: /* If the user has selected "All" for agent group paramter , display the default group of the user */
1286: IF (v_group_id = -999 or v_group_id is null) THEN
1287: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')

Line 1289: FROM dual;

1285: /* If the user has selected "All" for agent group paramter , display the default group of the user */
1286: IF (v_group_id = -999 or v_group_id is null) THEN
1287: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
1288: INTO v_group_id
1289: FROM dual;
1290: END IF;
1291:
1292: /* or the user has selected "all" as agent group paramter and (s)he is not assigned to any default group */
1293: IF (v_group_id IS NULL) THEN