APPS.BEN_DM_UPLOAD_DK dependencies on PER_JOBS

Line 2538: -- DK Resolve For Table PER_JOBS

2534: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2535: end;
2536:
2537: --
2538: -- DK Resolve For Table PER_JOBS
2539: --
2540: procedure get_dk_frm_job is
2541: --
2542: -- cursor to Fetch the DK for PER_JOBS.JOB_ID

Line 2542: -- cursor to Fetch the DK for PER_JOBS.JOB_ID

2538: -- DK Resolve For Table PER_JOBS
2539: --
2540: procedure get_dk_frm_job is
2541: --
2542: -- cursor to Fetch the DK for PER_JOBS.JOB_ID
2543: --
2544: cursor csr_get_dk_job (c_business_group_id number, c_source_key varchar2) is
2545: select job_id
2546: from per_jobs

Line 2546: from per_jobs

2542: -- cursor to Fetch the DK for PER_JOBS.JOB_ID
2543: --
2544: cursor csr_get_dk_job (c_business_group_id number, c_source_key varchar2) is
2545: select job_id
2546: from per_jobs
2547: where name = c_source_key
2548: ;
2549:
2550: cursor csr_get_all_job is

Line 2553: where table_name = 'PER_JOBS'

2549:
2550: cursor csr_get_all_job is
2551: select *
2552: from ben_dm_resolve_mappings
2553: where table_name = 'PER_JOBS'
2554: and target_id is null;
2555:
2556: -- Declare local variables
2557: l_proc varchar2(72) := g_package || 'get_dk_frm_job';

Line 2566: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_JOBS

2562:
2563: begin
2564:
2565: --
2566: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_JOBS
2567: --
2568: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2569: for x in csr_get_all_job loop
2570: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3234: -- DK Resolve for Table PER_JOBS

3230:
3231: -- DK Resolve for Table PER_GRADES
3232: get_dk_frm_gra;
3233:
3234: -- DK Resolve for Table PER_JOBS
3235: get_dk_frm_job;
3236:
3237: -- DK Resolve for Table PER_PAY_BASES
3238: get_dk_frm_pyb;