DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on PER_PARTICIPANTS

Line 1892: -- Cursor to check if the appraisal is used in PER_PARTICIPANTS

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
1893:
1894: cursor csr_apr_exists_in_per_part is
1895: select 'Y'
1896: from per_participants par

Line 1896: from per_participants par

1892: -- Cursor to check if the appraisal is used in PER_PARTICIPANTS
1893:
1894: cursor csr_apr_exists_in_per_part is
1895: select 'Y'
1896: from per_participants par
1897: where par.participation_in_id = p_appraisal_id
1898: and par.participation_in_table = 'PER_APPRAISALS'
1899: and par.participation_in_column = 'APPRAISAL_ID';
1900: