APPS.PER_ASG_BUS2 dependencies on IRC_POSTING_CONTENTS

Line 5782: l_posting_content_id irc_posting_contents.posting_content_id%type;

5778: --
5779: l_proc varchar2(72) := g_package||'chk_posting_content_id';
5780: l_api_updating boolean;
5781: l_count number;
5782: l_posting_content_id irc_posting_contents.posting_content_id%type;
5783: --
5784: cursor irc_exists(p_posting_content_id number) is
5785: select posting_content_id
5786: from irc_posting_contents

Line 5786: from irc_posting_contents

5782: l_posting_content_id irc_posting_contents.posting_content_id%type;
5783: --
5784: cursor irc_exists(p_posting_content_id number) is
5785: select posting_content_id
5786: from irc_posting_contents
5787: where posting_content_id = p_posting_content_id
5788: and rownum = 1;
5789: --
5790: begin

Line 5811: -- posting_content_id must exist in irc_posting_contents

5807: -- Check if posting_content_id is not null
5808: --
5809: if p_posting_content_id IS NOT NULL then
5810: --
5811: -- posting_content_id must exist in irc_posting_contents
5812: --
5813: open irc_exists(p_posting_content_id);
5814: fetch irc_exists into l_posting_content_id;
5815: --