APPS.PER_RAA_BUS dependencies on IRC_POSTING_CONTENTS

Line 1062: -- Checks that posting_content_id exists in IRC_POSTING_CONTENTS

1058: -- |-------------------< chk_posting_content_id >------------------------------|
1059: -- -----------------------------------------------------------------------------
1060: --
1061: -- Description:
1062: -- Checks that posting_content_id exists in IRC_POSTING_CONTENTS
1063: --
1064: -- Prerequisites:
1065: -- g_old_rec has been populated with details of the values currently in
1066: -- the database.

Line 1099: select null from IRC_POSTING_CONTENTS ipc

1095: l_posting_content_id varchar2(1);
1096: l_api_updating boolean;
1097:
1098: cursor csr_posting_content_id is
1099: select null from IRC_POSTING_CONTENTS ipc
1100: where ipc.posting_content_id = p_posting_content_id;
1101: --
1102: begin
1103: hr_utility.set_location('Entering:'||l_proc,10);

Line 1114: -- check that posting_content_id exists in IRC_POSTING_CONTENTS.

1110: p_posting_content_id <>
1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)
1112: ) or (NOT l_api_updating) then
1113:
1114: -- check that posting_content_id exists in IRC_POSTING_CONTENTS.
1115: hr_utility.set_location(l_proc,30);
1116: open csr_posting_content_id;
1117: fetch csr_posting_content_id into l_posting_content_id;
1118: if csr_posting_content_id%NOTFOUND then