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_APT_BUS dependencies on PER_ASSESSMENT_TYPES

Line 333: from per_assessment_types

329:
330: Cursor csr_appraisal_type_exists
331: is
332: select business_group_id
333: from per_assessment_types
334: where assessment_type_id = p_assessment_type_id
335: and type = 'COMPETENCE';
336:
337: -- Cursor to check if the assessment type is

Line 345: from per_assessment_types

341: -- p_date_to nvl into g_sot from g_eot.
342: Cursor csr_assessment_type_valid
343: is
344: select 'Y'
345: from per_assessment_types
346: where assessment_type_id = p_assessment_type_id
347: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
348: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
349: -- Bug 3947233 Ends Here

Line 466: from per_assessment_types

462:
463: Cursor csr_appraisal_type_exists
464: is
465: select business_group_id
466: from per_assessment_types
467: where assessment_type_id = p_objective_asmnt_type_id
468: and type = 'OBJECTIVE';
469:
470: -- Cursor to check if the assessment type is

Line 478: from per_assessment_types

474: -- p_date_to nvl into g_sot from g_eot.
475: Cursor csr_assessment_type_valid
476: is
477: select 'Y'
478: from per_assessment_types
479: where assessment_type_id = p_objective_asmnt_type_id
480: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
481: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
482: -- Bug 3947233 Ends Here