APPS.PAY_US_DB_PER_SETUP dependencies on PER_GRADES

Line 2023: FROM per_grades grd

2019: --
2020: --
2021: SELECT 'Y'
2022: INTO grd_check
2023: FROM per_grades grd
2024: WHERE (grd.grade_id <> p_grade_id
2025: OR p_grade_id IS NULL)
2026: AND p_grade_name = grd.name
2027: AND p_business_group_id = grd.business_group_id + 0;

Line 2145: SELECT per_grades_s.nextval

2141: begin
2142: --
2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);
2144: --
2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;
2148: --
2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);

Line 2155: INSERT INTO per_grades

2151: unique_name(l_business_group_id, l_grade_id, p_name);
2152: --
2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);
2154: --
2155: INSERT INTO per_grades
2156: (GRADE_ID
2157: ,BUSINESS_GROUP_ID
2158: ,GRADE_DEFINITION_ID
2159: ,DATE_FROM

Line 2181: FROM per_grades pg

2177: ,0
2178: ,0
2179: ,0
2180: ,SYSDATE
2181: FROM per_grades pg
2182: WHERE pg.business_group_id + 0 = l_business_group_id ;
2183: --
2184: --
2185: return l_grade_id;