DBA Data[Home] [Help]

APPS.PER_APT_BUS dependencies on HR_QUEST_ANSWERS

Line 611: -- according to hr_quest_answers.

607: -- and apa.type = 'APPRAISAL'
608: -- and apr.appraisal_template_id = p_appraisal_template_id;
609:
610: -- Cursor to check if questionnaire template can be updated,
611: -- according to hr_quest_answers.
612: cursor csr_question_update1 is
613: select 'Y'
614: from hr_quest_answers hqa
615: where hqa.type = 'APPRAISAL'

Line 614: from hr_quest_answers hqa

610: -- Cursor to check if questionnaire template can be updated,
611: -- according to hr_quest_answers.
612: cursor csr_question_update1 is
613: select 'Y'
614: from hr_quest_answers hqa
615: where hqa.type = 'APPRAISAL'
616: and hqa.type_object_id in (select appraisal_id
617: from per_appraisals apr
618: where apr.appraisal_template_id

Line 800: -- according to hr_quest_answers.

796: -- and apa.type = 'APPRAISAL'
797: -- and apr.appraisal_template_id = p_appraisal_template_id;
798:
799: -- Cursor to check if questionnaire template can be updated,
800: -- according to hr_quest_answers.
801: cursor csr_question_update1 is
802: select 'Y'
803: from hr_quest_answers hqa
804: where hqa.type = 'APPRAISAL'

Line 803: from hr_quest_answers hqa

799: -- Cursor to check if questionnaire template can be updated,
800: -- according to hr_quest_answers.
801: cursor csr_question_update1 is
802: select 'Y'
803: from hr_quest_answers hqa
804: where hqa.type = 'APPRAISAL'
805: and hqa.type_object_id in (select appraisal_id
806: from per_appraisals apr
807: where apr.appraisal_template_id