APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_JOBS

Line 2704: -- DK Resolve from Table PER_JOBS

2700: --
2701: end if;
2702: end;
2703: --
2704: -- DK Resolve from Table PER_JOBS
2705: --
2706: procedure get_dk_frm_job (p_business_group_name in VARCHAR2
2707: ,p_source_id in NUMBER
2708: ,p_resolve_mapping_id out nocopy NUMBER) is

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

2706: procedure get_dk_frm_job (p_business_group_name in VARCHAR2
2707: ,p_source_id in NUMBER
2708: ,p_resolve_mapping_id out nocopy NUMBER) is
2709: --
2710: -- cursor to Fetch the DK for PER_JOBS.JOB_ID
2711: --
2712: cursor csr_get_dk_job is
2713: select name
2714: from per_jobs

Line 2714: from per_jobs

2710: -- cursor to Fetch the DK for PER_JOBS.JOB_ID
2711: --
2712: cursor csr_get_dk_job is
2713: select name
2714: from per_jobs
2715: where job_id = p_source_id;
2716:
2717: -- Declare local variables
2718: l_proc varchar2(72) := g_package || 'get_dk_frm_job';

Line 2721: l_table_name varchar2(30) := 'PER_JOBS';

2717: -- Declare local variables
2718: l_proc varchar2(72) := g_package || 'get_dk_frm_job';
2719: l_row_fetched boolean := FALSE;
2720: l_table_rec csr_get_dk_job%rowtype;
2721: l_table_name varchar2(30) := 'PER_JOBS';
2722: l_column_name varchar2(30) := 'JOB_ID';
2723: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2724:
2725: begin