APPS.BIX_AGT_COLLECT dependencies on IEU_SH_SESSIONS

Line 24: from ieu_sh_sessions iss

20: select sum((iss.end_date_time - iss.begin_date_time) * 24 * 3600) login_time,
21: iss.resource_id,
22: iss.begin_date_time ,
23: iss.end_date_time
24: from ieu_sh_sessions iss
25: where iss.begin_date_time between p_start_date and p_end_date
26: and iss.active_flag is NULL
27: group by iss.resource_id, iss.begin_date_time,iss.end_date_time;
28:

Line 31: from ieu_sh_activities isa, ieu_sh_sessions iss

27: group by iss.resource_id, iss.begin_date_time,iss.end_date_time;
28:
29: CURSOR get_available_time IS
30: select sum((isa.end_date_time - isa.begin_date_time) * 24 * 3600) available_time
31: from ieu_sh_activities isa, ieu_sh_sessions iss
32: where isa.session_id = iss.session_id
33: and isa.activity_type_code = 'WORK_REQUEST'
34: and iss.begin_date_time = v_ses_start_date
35: and iss.ACTIVE_FLAG is NULL

Line 64: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys, ieu_sh_activities isa, ieu_sh_sessions iss

60:
61: /*
62: CURSOR get_wrap_time IS
63: SELECT sum((int.end_date_time - seg.end_date_time) * 24 * 3600) wrap_time
64: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys, ieu_sh_activities isa, ieu_sh_sessions iss
65: WHERE iss.resource_id = v_resource_id
66: AND iss.begin_date_time = v_day
67: AND iss.active_flag is null
68: AND isa.session_id = iss.session_id