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 1817: -- - per_assign_proposal_answers

1813: -- Description:
1814: -- - Validates that an appraisal cannot be deleted if:
1815: -- -Appraisal overall_performance_level_id is not null
1816: -- -Appraisal is referenced in:
1817: -- - per_assign_proposal_answers
1818: -- - per_objectives
1819: -- - per_assessments
1820: -- - per_performance_ratings
1821:

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

1833: -- Post Failure:
1834: -- An application error is raised and processing is terminated if any of
1835: -- the following cases are found :
1836: -- - appraisal overall_performance_level_id is not null
1837: -- - appraisal is refrenced in per_assign_proposal_answers, per_objectives
1838: -- per_assessments, per_performance_ratings
1839:
1840: -- Access Status
1841: -- Internal Table Handler Use Only.

Line 1854: -- Cursor to check if the appraisal is used in per_assign_proposal_answers

1850: l_exists varchar2(1);
1851: l_proc varchar2(72) := g_package||'chk_appraisal_delete';
1852:
1853:
1854: -- Cursor to check if the appraisal is used in per_assign_proposal_answers
1855:
1856: -- Change to use exists for WWBUG 1833930.
1857:
1858: cursor csr_apr_exists_in_answers

Line 1863: from per_assign_proposal_answers

1859: is
1860: select 'Y'
1861: from dual
1862: where exists (select null
1863: from per_assign_proposal_answers
1864: where answer_for_key = p_appraisal_id);
1865: -- 07/03/97 Changed
1866:
1867: -- Cursor to check if the appraisal is used in per_objectives