APPS.PAY_US_DB_PER_SETUP dependencies on PER_POSITIONS

Line 1701: FROM per_positions pos

1697: --
1698: --
1699: SELECT 'Y'
1700: INTO pos_check
1701: FROM per_positions pos
1702: WHERE (pos.position_id <> p_position_id
1703: OR p_position_id IS NULL)
1704: AND p_position_name = pos.name
1705: AND p_business_group_id = pos.business_group_id + 0;

Line 1822: SELECT per_positions_s.nextval

1818: begin
1819: --
1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);
1821: --
1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;
1825: --
1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);

Line 1832: INSERT INTO per_positions

1828: unique_name(l_business_group_id, l_position_id, p_name);
1829: --
1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);
1831: --
1832: INSERT INTO per_positions
1833: (POSITION_ID
1834: ,BUSINESS_GROUP_ID
1835: ,JOB_ID
1836: ,ORGANIZATION_ID

Line 1931: FROM per_positions

1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);
1928: --
1929: SELECT position_id
1930: INTO l_relief_position_id
1931: FROM per_positions
1932: WHERE name = p_relief_position;
1933: --
1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);
1935: --

Line 1938: FROM per_positions

1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);
1935: --
1936: SELECT position_id
1937: INTO l_successor_position_id
1938: FROM per_positions
1939: WHERE name = p_successor_position;
1940: --
1941: exception when NO_DATA_FOUND then null;
1942: end;