APPS.BIX_AGT_COLLECT dependencies on IEU_SH_ACTIVITIES

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 52: FROM jtf_ih_activities act, ieu_sh_activities isa, jtf_ih_interactions int, jtf_ih_action_items_vl actitems

48:
49: /*
50: CURSOR get_wrap_time IS
51: SELECT sum((act.end_date_time - act.start_date_time) * 24 * 3600) wrap_time
52: FROM jtf_ih_activities act, ieu_sh_activities isa, jtf_ih_interactions int, jtf_ih_action_items_vl actitems
53: WHERE act.media_id = isa.media_id
54: AND act.interaction_id = int.interaction_id
55: AND int.resource_id = v_resource_id
56: AND (act.start_date_time, 'DD/MON/YYYY') = v_day

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