DBA Data[Home] [Help]

APPS.PER_DB_PER_ADDITIONAL dependencies on PER_GRADES_VL

Line 1058: FROM per_grades_vl

1054: else
1055: hr_utility.set_location('per_db_per_additional.create_applicant',24);
1056: SELECT grade_id
1057: INTO l_grade_id
1058: FROM per_grades_vl
1059: WHERE name = p_grade
1060: AND business_group_id + 0 = l_business_group_id
1061: AND l_effective_start_date BETWEEN date_from
1062: AND nvl(date_to,to_date('4712/12/31',

Line 1456: FROM per_grades_vl

1452: else
1453: hr_utility.set_location('per_db_per_additional.create_employee',30);
1454: SELECT grade_id
1455: INTO l_grade_id
1456: FROM per_grades_vl
1457: WHERE name = p_grade
1458: AND business_group_id + 0 = l_business_group_id
1459: AND l_effective_start_date BETWEEN date_from
1460: AND nvl(date_to,to_date('4712/12/31',

Line 1881: FROM per_grades_vl

1877: else
1878: hr_utility.set_location('per_db_per_additional.create_secondary_assign',25);
1879: SELECT grade_id
1880: INTO l_grade_id
1881: FROM per_grades_vl
1882: WHERE name = p_grade
1883: AND business_group_id + 0 = l_business_group_id
1884: AND l_effective_start_date BETWEEN date_from
1885: AND nvl(date_to,to_date('4712/12/31',

Line 2021: FROM per_grades_vl

2017: else
2018: hr_utility.set_location('per_db_per_additional.create_secondary_assign',52);
2019: SELECT grade_id
2020: INTO l_grade_id
2021: FROM per_grades_vl
2022: WHERE name = p_grade
2023: AND business_group_id + 0 = l_business_group_id
2024: AND l_effective_start_date BETWEEN date_from
2025: AND nvl(date_to,to_date('4712/12/31',