APPS.PER_ASG_BUS2 dependencies on IRC_POSTING_CONTENTS

Line 5987: l_posting_content_id irc_posting_contents.posting_content_id%type;

5983: --
5984: l_proc varchar2(72) := g_package||'chk_posting_content_id';
5985: l_api_updating boolean;
5986: l_count number;
5987: l_posting_content_id irc_posting_contents.posting_content_id%type;
5988: --
5989: cursor irc_exists(p_posting_content_id number) is
5990: select posting_content_id
5991: from irc_posting_contents

Line 5991: from irc_posting_contents

5987: l_posting_content_id irc_posting_contents.posting_content_id%type;
5988: --
5989: cursor irc_exists(p_posting_content_id number) is
5990: select posting_content_id
5991: from irc_posting_contents
5992: where posting_content_id = p_posting_content_id
5993: and rownum = 1;
5994: --
5995: begin

Line 6016: -- posting_content_id must exist in irc_posting_contents

6012: -- Check if posting_content_id is not null
6013: --
6014: if p_posting_content_id IS NOT NULL then
6015: --
6016: -- posting_content_id must exist in irc_posting_contents
6017: --
6018: open irc_exists(p_posting_content_id);
6019: fetch irc_exists into l_posting_content_id;
6020: --