APPS.IRC_MRS_UPGRADE dependencies on IRC_POSTING_CONTENTS

Line 43: ,irc_posting_contents ipc

39: ,pra.object_version_number object_version_number
40: ,pra.date_end date_end
41: ,pra.posting_content_id posting_content_id
42: from per_recruitment_activities pra
43: ,irc_posting_contents ipc
44: where ipc.posting_content_id = pra.posting_content_id
45: and ipc.posting_content_id between p_start_pkid and p_end_pkid
46: and (pra.internal_posting is not null or pra.external_posting is not null);
47: --