APPS.PER_DB_PER_SETUP dependencies on PER_GRADES

Line 1561: FROM per_grades grd

1557: --
1558: --
1559: SELECT 'Y'
1560: INTO grd_check
1561: FROM per_grades grd
1562: WHERE (grd.grade_id <> p_grade_id
1563: OR p_grade_id IS NULL)
1564: AND p_grade_name = grd.name
1565: AND p_business_group_id = grd.business_group_id + 0;

Line 1683: SELECT per_grades_s.nextval

1679: begin
1680: --
1681: hr_utility.set_location('per_db_per_setup.insert_grade',1);
1682: --
1683: SELECT per_grades_s.nextval
1684: INTO l_grade_id
1685: FROM sys.dual;
1686: --
1687: hr_utility.set_location('per_db_per_setup.insert_grade',2);

Line 1693: INSERT INTO per_grades

1689: unique_name(l_business_group_id, l_grade_id, p_name);
1690: --
1691: hr_utility.set_location('per_db_per_setup.insert_grade',3);
1692: --
1693: INSERT INTO per_grades
1694: (GRADE_ID
1695: ,BUSINESS_GROUP_ID
1696: ,GRADE_DEFINITION_ID
1697: ,DATE_FROM

Line 1719: FROM per_grades pg

1715: ,0
1716: ,0
1717: ,0
1718: ,SYSDATE
1719: FROM per_grades pg
1720: WHERE pg.business_group_id + 0 = l_business_group_id ;
1721: --
1722: --
1723: return l_grade_id;