APPS.PER_APT_BUS dependencies on HR_QUESTIONNAIRES

Line 587: l_bus_grp_id hr_questionnaires.business_group_id%TYPE;

583:
584: l_exists varchar2(1);
585: l_api_updating boolean;
586: l_proc varchar2(72) := g_package||'chk_question_template';
587: l_bus_grp_id hr_questionnaires.business_group_id%TYPE;
588: -- l_type per_proposal_templates.type%TYPE;
589:
590: -- Cursor to check if appraisal exists
591:

Line 595: from hr_questionnaires qsn

591:
592: Cursor csr_question_template_exists
593: is
594: select business_group_id
595: from hr_questionnaires qsn
596: where qsn.questionnaire_template_id = p_questionnaire_template_id;
597:
598: -- Cursor to check if the questionnnaire template
599: -- can be updated

Line 776: l_bus_grp_id hr_questionnaires.business_group_id%TYPE;

772:
773: l_exists varchar2(1);
774: l_api_updating boolean;
775: l_proc varchar2(72) := g_package||'chk_ma_question_template';
776: l_bus_grp_id hr_questionnaires.business_group_id%TYPE;
777: -- l_type per_proposal_templates.type%TYPE;
778:
779: -- Cursor to check if appraisal exists
780:

Line 784: from hr_questionnaires qsn

780:
781: Cursor csr_question_template_exists
782: is
783: select business_group_id
784: from hr_questionnaires qsn
785: where qsn.questionnaire_template_id = p_ma_quest_template_id;
786:
787: -- Cursor to check if the questionnnaire template
788: -- can be updated