DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on PER_PARTICIPANTS

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

2056: from per_performance_ratings
2057: where appraisal_id = p_appraisal_id;
2058:
2059:
2060: -- Cursor to check if the appraisal is used in PER_PARTICIPANTS
2061:
2062: cursor csr_apr_exists_in_per_part is
2063: select 'Y'
2064: from per_participants par

Line 2064: from per_participants par

2060: -- Cursor to check if the appraisal is used in PER_PARTICIPANTS
2061:
2062: cursor csr_apr_exists_in_per_part is
2063: select 'Y'
2064: from per_participants par
2065: where par.participation_in_id = p_appraisal_id
2066: and par.participation_in_table = 'PER_APPRAISALS'
2067: and par.participation_in_column = 'APPRAISAL_ID';
2068: