DBA Data[Home] [Help]

APPS.PER_ASR_BUS dependencies on PER_ASSESSMENTS

Line 175: -- sure that no rows reference it in per_assessments.

171: -- ----------------------------------------------------------------------------
172: --
173: -- DESCRIPTION
174: -- Before an assessment group can be removed, a check is carried out to make
175: -- sure that no rows reference it in per_assessments.
176: -- If they do, an error is raised.
177: --
178: -- PRE-REQUISITES
179: --

Line 199: from per_assessments asn

195: l_proc varchar2(72):=g_package||'chk_ref_rows_asn';
196: --
197: cursor csr_chk_ref_rows_asn is
198: select null
199: from per_assessments asn
200: where p_assessment_group_id = asn.assessment_group_id;
201: --
202: l_exists varchar2(1);
203: --