APPS.CCT_CONCURRENT_PUB dependencies on JTF_IH_MEDIA_ITEMS

Line 129: from cct_media_items a, jtf_ih_media_items b

125: -- dbms_output.put_line('Worker Program Started 2');
126:
127: declare cursor c1 is
128: select a.media_item_id, a.last_update_date, a.status, a.classification, a.attribute1, a.attribute2, b.start_date_time
129: from cct_media_items a, jtf_ih_media_items b
130: where a.media_type <> 1 and a.media_item_id = b.media_id and b.active = 'Y';
131:
132: begin
133: -- fnd_file.put_line(fnd_file.log,'Cursor declared');

Line 477: select media_id, start_date_time from jtf_ih_media_items where active = 'Y' and media_id in

473:
474: l_timeout_in_minutes := 60*p_timeout_in_hrs;
475:
476: declare cursor c1 is
477: select media_id, start_date_time from jtf_ih_media_items where active = 'Y' and media_id in
478: (select media_item_id from cct_media_items where media_type <> 1 and status NOT IN (1,2))
479: and start_date_time <= (sysdate - (l_timeout_in_minutes/1440));
480:
481: begin

Line 602: -- force delete remainder media items that are in cct_media_items but are inactive in jtf_ih_media_items.

598: end;
599: end;
600: end loop;
601:
602: -- force delete remainder media items that are in cct_media_items but are inactive in jtf_ih_media_items.
603:
604: delete from CCT_MEDIA_ITEMS where
605: media_type <> 1 and status NOT IN (1,2) and creation_date <= (sysdate - (l_timeout_in_minutes/1440)) ;
606: