DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on PER_OBJECTIVES

Line 1986: -- - per_objectives

1982: -- - Validates that an appraisal cannot be deleted if:
1983: -- -Appraisal overall_performance_level_id is not null
1984: -- -Appraisal is referenced in:
1985: -- - per_assign_proposal_answers
1986: -- - per_objectives
1987: -- - per_assessments
1988: -- - per_performance_ratings
1989:
1990: -- Pre_conditions:

Line 2005: -- - appraisal is refrenced in per_assign_proposal_answers, per_objectives

2001: -- Post Failure:
2002: -- An application error is raised and processing is terminated if any of
2003: -- the following cases are found :
2004: -- - appraisal overall_performance_level_id is not null
2005: -- - appraisal is refrenced in per_assign_proposal_answers, per_objectives
2006: -- per_assessments, per_performance_ratings
2007:
2008: -- Access Status
2009: -- Internal Table Handler Use Only.

Line 2035: -- Cursor to check if the appraisal is used in per_objectives

2031: from per_assign_proposal_answers
2032: where answer_for_key = p_appraisal_id);
2033: -- 07/03/97 Changed
2034:
2035: -- Cursor to check if the appraisal is used in per_objectives
2036:
2037: cursor csr_apr_exits_in_objectives
2038: is
2039: select 'Y'

Line 2040: from per_objectives

2036:
2037: cursor csr_apr_exits_in_objectives
2038: is
2039: select 'Y'
2040: from per_objectives
2041: where appraisal_id = p_appraisal_id;
2042:
2043: -- Cursor to check if the appraisal is used in per_assessments
2044: