APPS.BIX_UWQ_SUMMARY_PKG dependencies on IEU_SH_SESSIONS

Line 85: FROM ieu_sh_sessions

81: --Select the max and min dates
82: --
83: SELECT trunc(min(begin_date_time)), trunc(max(begin_date_time))
84: INTO v_min_date, v_max_date
85: FROM ieu_sh_sessions
86: WHERE (
87: last_update_date BETWEEN v_collect_start_date AND v_collect_end_date
88: OR ACTIVE_FLAG = 'T'
89: )

Line 260: from ieu_sh_sessions ses

256: max(decode(trunc(begin_date_time), (p_insert_date-6),1,0)) DAY6_LOGIN,
257: round((sum(decode(trunc(begin_date_time), (p_insert_date-6),
258: (decode(end_date_time,NULL,sysdate,end_date_time)-begin_date_time)
259: ,0)))*24*3600) DAY6_DURATION
260: from ieu_sh_sessions ses
261: where begin_date_time > p_insert_date-62
262: and begin_date_time < p_insert_date+1
263: and application_id = 696
264: group by ses.resource_id, p_insert_date;

Line 378: FROM ieu_sh_sessions

374: INTO v_prior_week_login
375: FROM
376: (
377: SELECT DISTINCT resource_id, trunc(begin_date_time)
378: FROM ieu_sh_sessions
379: WHERE resource_id = rec_days.resource_id
380: AND begin_date_time BETWEEN v_week_start_date-7 AND v_week_start_date-1+.99998843
381: AND application_id = 696
382: );

Line 386: FROM ieu_sh_sessions

382: );
383:
384: SELECT round(sum(decode(end_date_time,NULL,sysdate,end_date_time)-begin_date_time)*24*3600)
385: INTO v_prior_week_duration
386: FROM ieu_sh_sessions
387: WHERE resource_id = rec_days.resource_id
388: AND begin_date_time BETWEEN v_week_start_date-7 AND v_week_start_date-1+.99998843
389: AND application_id = 696;
390:

Line 424: FROM ieu_sh_sessions

420: INTO v_current_week_login
421: FROM
422: (
423: SELECT DISTINCT resource_id, trunc(begin_date_time)
424: FROM ieu_sh_sessions
425: WHERE resource_id = rec_days.resource_id
426: AND begin_date_time BETWEEN v_week_start_date AND v_insert_date+.99998843
427: AND application_id = 696
428: );

Line 432: FROM ieu_sh_sessions

428: );
429:
430: SELECT round(sum(decode(end_date_time,NULL,sysdate,end_date_time)-begin_date_time)*24*3600)
431: INTO v_current_week_duration
432: FROM ieu_sh_sessions
433: WHERE resource_id = rec_days.resource_id
434: AND begin_date_time BETWEEN v_week_start_date AND v_insert_date+.99998843
435: AND application_id = 696
436: ;

Line 482: FROM ieu_sh_sessions

478: INTO v_prior_month_login
479: FROM
480: (
481: SELECT DISTINCT resource_id, trunc(begin_date_time)
482: FROM ieu_sh_sessions
483: WHERE resource_id = rec_days.resource_id
484: AND to_char(begin_date_time,'MM/YYYY') = to_char(add_months(v_insert_date,-1), 'MM/YYYY')
485: AND application_id = 696
486: );

Line 490: FROM ieu_sh_sessions

486: );
487:
488: SELECT round(sum(decode(end_date_time,NULL,sysdate,end_date_time)-begin_date_time)*24*3600)
489: INTO v_prior_month_duration
490: FROM ieu_sh_sessions
491: WHERE resource_id = rec_days.resource_id
492: AND to_char(begin_date_time,'MM/YYYY') = to_char(add_months(v_insert_date,-1), 'MM/YYYY')
493: AND application_id = 696;
494:

Line 529: FROM ieu_sh_sessions

525: INTO v_current_month_login
526: FROM
527: (
528: SELECT DISTINCT resource_id, trunc(begin_date_time)
529: FROM ieu_sh_sessions
530: WHERE resource_id = rec_days.resource_id
531: AND to_char(begin_date_time,'MM/YYYY') = to_char(v_insert_date, 'MM/YYYY')
532: AND begin_date_time <= v_insert_date+.99998843
533: AND application_id = 696

Line 539: FROM ieu_sh_sessions

535: ;
536:
537: SELECT round(sum(decode(end_date_time,NULL,sysdate,end_date_time)-begin_date_time)*24*3600)
538: INTO v_current_month_duration
539: FROM ieu_sh_sessions
540: WHERE resource_id = rec_days.resource_id
541: AND to_char(begin_date_time,'MM/YYYY') = to_char(v_insert_date, 'MM/YYYY')
542: AND begin_date_time <= v_insert_date+.99998843
543: AND application_id = 696;