APPS.IEU_SH_CON_PVT dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 161: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE

157: -- dbms_output.put_line('Activity Id : '||act_cur_rec_1.activity_id||' Session Id : '||ses_cur_rec.session_id);
158:
159: select count(*), max(end_date_time)
160: into l_count_lc_segs, l_cal_end_date_time
161: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
162: media_id = act_cur_rec_1.media_id AND
163: resource_id = ses_cur_rec.resource_id AND
164: ACTIVE = l_media_not_active;
165:

Line 168: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE

164: ACTIVE = l_media_not_active;
165:
166: select count(*)
167: into l_count_lc_segs_active
168: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
169: media_id = act_cur_rec_1.media_id AND
170: resource_id = ses_cur_rec.resource_id AND
171: ACTIVE = l_media_active;
172:

Line 385: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE

381: SESSION_ID = cur_act.session_id;
382:
383: select count(*), max(end_date_time)
384: into l_count_lc_segs, l_cal_end_date_time
385: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
386: media_id = cur_act.media_id AND
387: resource_id = l_act_resource_id AND
388: ACTIVE = l_media_not_active;
389:

Line 487: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE

483: SESSION_ID = cur_act.session_id;
484:
485: select count(*), max(end_date_time)
486: into l_count_lc_segs, l_cal_end_date_time
487: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
488: media_id = cur_act.media_id AND
489: resource_id = l_act_resource_id AND
490: ACTIVE = l_media_not_active;
491:

Line 564: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE

560: SESSION_ID = act_cur_rec_2.session_id;
561:
562: select count(*), max(end_date_time)
563: into l_count_lc_segs, l_cal_end_date_time
564: FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
565: media_id = act_cur_rec_2.media_id AND
566: resource_id = l_act_resource_id AND
567: ACTIVE = l_media_not_active;
568: