DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on PER_OBJECTIVES

Line 1818: -- - per_objectives

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:
1822: -- Pre_conditions:

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

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
1868:
1869: cursor csr_apr_exits_in_objectives
1870: is
1871: select 'Y'

Line 1872: from per_objectives

1868:
1869: cursor csr_apr_exits_in_objectives
1870: is
1871: select 'Y'
1872: from per_objectives
1873: where appraisal_id = p_appraisal_id;
1874:
1875: -- Cursor to check if the appraisal is used in per_assessments
1876: