APPS.PER_OBJ_BUS dependencies on PER_PERFORMANCE_RATINGS

Line 632: -- - per_performance_ratings

628: --
629: -- Description:
630: -- - Validates that an objective cannot be deleted if:
631: -- objective is referenced in:
632: -- - per_performance_ratings
633: --
634: -- Pre_conditions:
635: -- - A valid objective_id
636: --

Line 648: -- - objective is referenced in per_performance_ratings

644: --
645: -- Post Failure:
646: -- An application error is raised and processing is terminated if any of
647: -- the following cases are found :
648: -- - objective is referenced in per_performance_ratings
649: --
650: -- Access Status
651: -- Internal Table Handler Use Only.
652: --

Line 663: -- Cursor to check if the objective is used in per_performance_ratings

659: l_exists varchar2(1);
660: l_proc varchar2(72) := g_package||'chk_objective_delete';
661: --
662: --
663: -- Cursor to check if the objective is used in per_performance_ratings
664: --
665: cursor csr_apr_exits_in_perf_rat
666: is
667: select 'Y'

Line 668: from per_performance_ratings

664: --
665: cursor csr_apr_exits_in_perf_rat
666: is
667: select 'Y'
668: from per_performance_ratings
669: where objective_id = p_objective_id;
670: --
671: -- Cursor to check if the objective is aligned with other objectives
672: --