DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on PER_PERFORMANCE_RATINGS

Line 1820: -- - per_performance_ratings

1816: -- -Appraisal is referenced in:
1817: -- - per_assign_proposal_answers
1818: -- - per_objectives
1819: -- - per_assessments
1820: -- - per_performance_ratings
1821:
1822: -- Pre_conditions:
1823: -- - A valid appraisal_id
1824:

Line 1838: -- per_assessments, per_performance_ratings

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.
1842:

Line 1883: -- Cursor to check if the appraisal is used in per_performance_ratings

1879: select 'Y'
1880: from per_assessments
1881: where appraisal_id = p_appraisal_id;
1882:
1883: -- Cursor to check if the appraisal is used in per_performance_ratings
1884:
1885: cursor csr_apr_exits_in_perf_rat
1886: is
1887: select 'Y'

Line 1888: from per_performance_ratings

1884:
1885: cursor csr_apr_exits_in_perf_rat
1886: is
1887: select 'Y'
1888: from per_performance_ratings
1889: where appraisal_id = p_appraisal_id;
1890:
1891:
1892: -- Cursor to check if the appraisal is used in PER_PARTICIPANTS