APPS.PER_APR_BUS dependencies on PER_APPRAISAL_TEMPLATES

Line 113: FROM per_appraisal_templates

109:
110: CURSOR csr_template_info
111: IS
112: SELECT show_future_term_employee
113: FROM per_appraisal_templates
114: WHERE appraisal_template_id = p_appraisal_template_id;
115:
116: l_show_term_employee VARCHAR2 (10) := 'Y';
117: l_future_term_exist VARCHAR2 (2) := 'N';

Line 381: FROM per_appraisal_templates

377: l_allow_appraisal BOOLEAN := FALSE;
378: --
379: cursor csr_allow_term_update is
380: SELECT NVL(SHOW_TERM_CONTIGENT,'N') term_cwk,NVL(SHOW_TERM_EMPLOYEE,'N') term_emp
381: FROM per_appraisal_templates
382: WHERE appraisal_template_id = p_rec.appraisal_template_id;
383: l_allow_term_emp varchar2(2) := 'N';
384: l_allow_term_cwk varchar2(2) := 'N';
385: begin

Line 758: from per_appraisal_templates

754:
755: Cursor csr_appraisal_exists
756: is
757: select business_group_id
758: from per_appraisal_templates
759: where appraisal_template_id = p_appraisal_template_id;
760:
761: -- Cursor to check if the appraisal template is
762: -- valid as of users effective date

Line 767: from per_appraisal_templates

763:
764: Cursor csr_appraisal_template_valid
765: is
766: select 'Y'
767: from per_appraisal_templates
768: where appraisal_template_id = p_appraisal_template_id
769: and p_effective_date between
770: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);
771:

Line 1667: FROM per_appraisal_templates

1663: l_valid boolean;
1664: --- if (NOT fnd_function.test('HR_VIEW_SYSAPPR_MGR_SS')
1665: CURSOR csr_term_settings (p_appraisal_template_id IN NUMBER) IS
1666: SELECT NVL (show_term_employee ,'N'), NVL (show_term_contigent,'N'), NVL (show_future_term_employee,'N')
1667: FROM per_appraisal_templates
1668: WHERE appraisal_template_id = p_appraisal_template_id;
1669: l_term_emp VARCHAR2(1);
1670: l_term_cwk VARCHAR2(1);
1671: l_future_term VARCHAR2(1);

Line 1904: from per_appraisal_templates

1900:
1901: Cursor csr_overall_rating_valid
1902: is
1903: select 'Y'
1904: from per_appraisal_templates
1905: where rating_scale_id = l_rating_scale_id
1906: and appraisal_template_id = p_appraisal_template_id;
1907:
1908: begin