DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on PER_VALID_GRADES

Line 2599: from per_valid_grades

2595: l_inv_pos_grade_warning boolean := false;
2596: --
2597: cursor csr_any_valid_grades is
2598: select 1
2599: from per_valid_grades
2600: where position_id = p_position_id
2601: and p_start_date between
2602: date_from and nvl(date_to,hr_api.g_eot);
2603: --

Line 2606: from per_valid_grades

2602: date_from and nvl(date_to,hr_api.g_eot);
2603: --
2604: cursor csr_valid_grade is
2605: select 1
2606: from per_valid_grades
2607: where position_id = p_position_id
2608: and grade_id = p_grade_id
2609: and p_start_date between
2610: date_from and nvl(date_to,hr_api.g_eot);

Line 2715: from per_valid_grades

2711: l_inv_job_grade_warning boolean := false;
2712: --
2713: cursor csr_any_valid_grades is
2714: select 1
2715: from per_valid_grades
2716: where job_id = p_job_id
2717: and p_start_date between
2718: date_from and nvl(date_to,hr_api.g_eot);
2719: --

Line 2722: from per_valid_grades

2718: date_from and nvl(date_to,hr_api.g_eot);
2719: --
2720: cursor csr_valid_grade is
2721: select 1
2722: from per_valid_grades
2723: where job_id = p_job_id
2724: and grade_id = p_grade_id
2725: and p_start_date between
2726: date_from and nvl(date_to,hr_api.g_eot);