eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APR_BUS dependencies on PER_APPRAISAL_TEMPLATES

Line 642: from per_appraisal_templates

638:
639: Cursor csr_appraisal_exists
640: is
641: select business_group_id
642: from per_appraisal_templates
643: where appraisal_template_id = p_appraisal_template_id;
644:
645: -- Cursor to check if the appraisal template is
646: -- valid as of users effective date

Line 651: from per_appraisal_templates

647:
648: Cursor csr_appraisal_template_valid
649: is
650: select 'Y'
651: from per_appraisal_templates
652: where appraisal_template_id = p_appraisal_template_id
653: and p_effective_date between
654: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);
655:

Line 1736: from per_appraisal_templates

1732:
1733: Cursor csr_overall_rating_valid
1734: is
1735: select 'Y'
1736: from per_appraisal_templates
1737: where rating_scale_id = l_rating_scale_id
1738: and appraisal_template_id = p_appraisal_template_id;
1739:
1740: begin