APPS.IRC_MRS_UPGRADE dependencies on IRC_ALL_RECRUITING_SITES_TL

Line 407: from irc_all_recruiting_sites_tl itl

403: ,dbms_lob.substr(irs.posting_url) posting_url
404: ,dbms_lob.substr(irs.redirection_url) redirection_url
405: from irc_all_recruiting_sites irs
406: where not exists (select null
407: from irc_all_recruiting_sites_tl itl
408: where itl.recruiting_site_id = irs.recruiting_site_id)
409: and irs.recruiting_site_id between p_start_pkid and p_end_pkid;
410: --
411: cursor csr_lang is