APPS.BIX_CCI_COLLECT dependencies on JTF_IH_INTERACTIONS

Line 53: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys

49: */
50:
51: CURSOR get_wrap_time(p_media_id NUMBER,p_resource_id NUMBER) IS
52: SELECT sum((int.end_date_time - seg.end_date_time) * 24 * 3600) wrap_time
53: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys
54: WHERE int.productive_time_amount = p_media_id
55: AND int.resource_id = p_resource_id
56: AND seg.media_id = p_media_id
57: AND seg.resource_id = p_resource_id