DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on HR_QUEST_ANSWERS

Line 670: from hr_quest_answers qsa

666: -- appraiser_person_id.
667:
668: cursor csr_answer_set_exists is
669: select null
670: from hr_quest_answers qsa
671: where p_appraisal_id = qsa.type_object_id
672: and qsa.type = 'APPRAISAL';
673:
674: begin

Line 2069: -- Cursor to check if the appraisal is used in HR_QUEST_ANSWERS

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:
2069: -- Cursor to check if the appraisal is used in HR_QUEST_ANSWERS
2070:
2071: cursor csr_apr_exists_in_hr_qsa is
2072: select 'Y'
2073: from hr_quest_answers qsa

Line 2073: from hr_quest_answers qsa

2069: -- Cursor to check if the appraisal is used in HR_QUEST_ANSWERS
2070:
2071: cursor csr_apr_exists_in_hr_qsa is
2072: select 'Y'
2073: from hr_quest_answers qsa
2074: where qsa.type_object_id = p_appraisal_id
2075: and qsa.type = 'APPRAISAL';
2076:
2077: begin