APPS.PER_DB_PER_SETUP dependencies on PER_JOBS

Line 863: FROM per_jobs jb

859: --
860: --
861: SELECT 'Y'
862: INTO job_check
863: FROM per_jobs jb
864: WHERE (jb.job_id <> p_job_id
865: OR p_job_id IS NULL)
866: AND p_job_name = jb.name
867: AND p_business_group_id = jb.business_group_id + 0;

Line 984: SELECT per_jobs_s.nextval

980: begin
981: --
982: hr_utility.set_location('per_db_per_setup.insert_job',1);
983: --
984: SELECT per_jobs_s.nextval
985: INTO l_job_id
986: FROM sys.dual;
987: --
988: hr_utility.set_location('per_db_per_setup.insert_job',2);

Line 994: INSERT INTO per_jobs

990: unique_name(l_business_group_id,l_job_id, p_name);
991: --
992: hr_utility.set_location('per_db_per_setup.insert_job',3);
993: --
994: INSERT INTO per_jobs
995: (JOB_ID
996: ,BUSINESS_GROUP_ID
997: ,JOB_DEFINITION_ID
998: ,DATE_FROM

Line 1442: FROM per_jobs

1438: hr_utility.set_location('per_db_per_setup.create_position',2);
1439: --
1440: SELECT job_id
1441: INTO l_job_id
1442: FROM per_jobs
1443: WHERE name = p_job
1444: AND business_group_id + 0 = l_business_group_id;
1445: --
1446: hr_utility.set_location('per_db_per_setup.create_position',3);