eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APR_BUS dependencies on PER_ASSIGN_PROPOSAL_ANSWERS

Line 1985: -- - per_assign_proposal_answers

1981: -- Description:
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:

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 2022: -- Cursor to check if the appraisal is used in per_assign_proposal_answers

2018: l_exists varchar2(1);
2019: l_proc varchar2(72) := g_package||'chk_appraisal_delete';
2020:
2021:
2022: -- Cursor to check if the appraisal is used in per_assign_proposal_answers
2023:
2024: -- Change to use exists for WWBUG 1833930.
2025:
2026: cursor csr_apr_exists_in_answers

Line 2031: from per_assign_proposal_answers

2027: is
2028: select 'Y'
2029: from dual
2030: where exists (select null
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