APPS.PAY_US_DB_PER_SETUP dependencies on PER_JOBS

Line 1425: FROM per_jobs jb

1421: --
1422: --
1423: SELECT 'Y'
1424: INTO job_check
1425: FROM per_jobs jb
1426: WHERE (jb.job_id <> p_job_id
1427: OR p_job_id IS NULL)
1428: AND p_job_name = jb.name
1429: AND p_business_group_id = jb.business_group_id + 0;

Line 1546: SELECT per_jobs_s.nextval

1542: begin
1543: --
1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);
1545: --
1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;
1549: --
1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);

Line 1556: INSERT INTO per_jobs

1552: unique_name(l_business_group_id,l_job_id, p_name);
1553: --
1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);
1555: --
1556: INSERT INTO per_jobs
1557: (JOB_ID
1558: ,BUSINESS_GROUP_ID
1559: ,JOB_DEFINITION_ID
1560: ,DATE_FROM

Line 1906: FROM per_jobs

1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);
1903: --
1904: SELECT job_id
1905: INTO l_job_id
1906: FROM per_jobs
1907: WHERE name = p_job
1908: AND business_group_id + 0 = l_business_group_id;
1909: --
1910: hr_utility.set_location('pay_us_db_per_setup.create_position',3);