APPS.HRI_BPL_FAST_FORMULA dependencies on PER_APPRAISAL_TEMPLATES

Line 925: FROM per_appraisal_templates pat

921: ,pat.name rating_template_name
922: ,prs.name rating_scale_name
923: ,prs.rating_scale_id
924: ,prl.step_value
925: FROM per_appraisal_templates pat
926: ,per_rating_scales prs
927: ,per_rating_levels prl
928: WHERE pat.business_group_id = cp_business_group_id
929: AND pat.rating_scale_id = prs.rating_scale_id

Line 943: l_rating_template_name per_appraisal_templates.name%TYPE DEFAULT NULL;

939: --
940: -- Declare local variables to store the latest business group and template
941: --
942: l_business_group_id NUMBER DEFAULT NULL;
943: l_rating_template_name per_appraisal_templates.name%TYPE DEFAULT NULL;
944: --
945: -- The string l_formula_text stores the code that has been generated for
946: -- a given business group.
947: --

Line 1133: FROM per_appraisal_templates pat

1129: -- that have associated rating scales.
1130: --
1131: CURSOR csr_rtng_tmplt_bsnss_grps IS
1132: SELECT DISTINCT pat.business_group_id business_group_id
1133: FROM per_appraisal_templates pat
1134: WHERE rating_scale_id IS NOT NULL
1135: ORDER BY business_group_id;
1136: --
1137: -- Declare record based on the csr_rtng_tmplt_bsnss_grps cursor