DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on HR_QUEST_ANSWERS

Line 554: from hr_quest_answers qsa

550: -- appraiser_person_id.
551:
552: cursor csr_answer_set_exists is
553: select null
554: from hr_quest_answers qsa
555: where p_appraisal_id = qsa.type_object_id
556: and qsa.type = 'APPRAISAL';
557:
558: begin

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

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:
1901: -- Cursor to check if the appraisal is used in HR_QUEST_ANSWERS
1902:
1903: cursor csr_apr_exists_in_hr_qsa is
1904: select 'Y'
1905: from hr_quest_answers qsa

Line 1905: from hr_quest_answers qsa

1901: -- Cursor to check if the appraisal is used in HR_QUEST_ANSWERS
1902:
1903: cursor csr_apr_exists_in_hr_qsa is
1904: select 'Y'
1905: from hr_quest_answers qsa
1906: where qsa.type_object_id = p_appraisal_id
1907: and qsa.type = 'APPRAISAL';
1908:
1909: begin