APPS.HR_DELETE dependencies on PER_JOBS

Line 730: (c_business_group_id per_jobs.business_group_id%TYPE)

726: FROM per_grades
727: WHERE business_group_id = c_business_group_id);
728: --
729: cursor csr_get_job
730: (c_business_group_id per_jobs.business_group_id%TYPE)
731: is
732: SELECT null
733: FROM sys.dual
734: WHERE exists(select null

Line 735: FROM per_jobs

731: is
732: SELECT null
733: FROM sys.dual
734: WHERE exists(select null
735: FROM per_jobs
736: WHERE business_group_id = c_business_group_id);
737: --
738: cursor csr_get_rca
739: (c_business_group_id

Line 1177: (c_business_group_id per_jobs.business_group_id%TYPE)

1173: FROM PER_POSITION_STRUCTURES
1174: WHERE business_group_id = c_business_group_id;
1175: --
1176: cursor csr_get_job
1177: (c_business_group_id per_jobs.business_group_id%TYPE)
1178: is
1179: SELECT null
1180: FROM per_jobs
1181: WHERE business_group_id = c_business_group_id;

Line 1180: FROM per_jobs

1176: cursor csr_get_job
1177: (c_business_group_id per_jobs.business_group_id%TYPE)
1178: is
1179: SELECT null
1180: FROM per_jobs
1181: WHERE business_group_id = c_business_group_id;
1182: --
1183: begin
1184: hr_utility.set_location('Entering: '||l_proc,10);

Line 1252: FROM per_jobs job

1248: hr_utility.set_location(l_proc,80);
1249: --
1250: DELETE FROM per_job_extra_info jei
1251: WHERE EXISTS (SELECT ''
1252: FROM per_jobs job
1253: WHERE job.job_id = jei.job_id
1254: AND job.business_group_id = p_business_group_id);
1255: hr_utility.set_location(l_proc,85);
1256: --

Line 1259: DELETE FROM per_jobs_tl jbt

1255: hr_utility.set_location(l_proc,85);
1256: --
1257: hr_utility.set_location(l_proc,86);
1258: --
1259: DELETE FROM per_jobs_tl jbt
1260: WHERE EXISTS (SELECT ''
1261: FROM per_jobs job
1262: WHERE job.job_id = jbt.job_id
1263: AND job.business_group_id = p_business_group_id);

Line 1261: FROM per_jobs job

1257: hr_utility.set_location(l_proc,86);
1258: --
1259: DELETE FROM per_jobs_tl jbt
1260: WHERE EXISTS (SELECT ''
1261: FROM per_jobs job
1262: WHERE job.job_id = jbt.job_id
1263: AND job.business_group_id = p_business_group_id);
1264: hr_utility.set_location(l_proc,87);
1265: --

Line 1266: DELETE FROM per_jobs job

1262: WHERE job.job_id = jbt.job_id
1263: AND job.business_group_id = p_business_group_id);
1264: hr_utility.set_location(l_proc,87);
1265: --
1266: DELETE FROM per_jobs job
1267: WHERE job.business_group_id = p_business_group_id;
1268: --
1269: hr_utility.set_location(l_proc,90);
1270: --