APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_PAY_BASES

Line 2769: -- DK Resolve from Table PER_PAY_BASES

2765: --
2766: end if;
2767: end;
2768: --
2769: -- DK Resolve from Table PER_PAY_BASES
2770: --
2771: procedure get_dk_frm_pyb (p_business_group_name in VARCHAR2
2772: ,p_source_id in NUMBER
2773: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2775: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID

2771: procedure get_dk_frm_pyb (p_business_group_name in VARCHAR2
2772: ,p_source_id in NUMBER
2773: ,p_resolve_mapping_id out nocopy NUMBER) is
2774: --
2775: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID
2776: --
2777: cursor csr_get_dk_pyb is
2778: select name
2779: from per_pay_bases

Line 2779: from per_pay_bases

2775: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID
2776: --
2777: cursor csr_get_dk_pyb is
2778: select name
2779: from per_pay_bases
2780: where pay_basis_id = p_source_id;
2781:
2782: -- Declare local variables
2783: l_proc varchar2(72) := g_package || 'get_dk_frm_pyb';

Line 2786: l_table_name varchar2(30) := 'PER_PAY_BASES';

2782: -- Declare local variables
2783: l_proc varchar2(72) := g_package || 'get_dk_frm_pyb';
2784: l_row_fetched boolean := FALSE;
2785: l_table_rec csr_get_dk_pyb%rowtype;
2786: l_table_name varchar2(30) := 'PER_PAY_BASES';
2787: l_column_name varchar2(30) := 'PAY_BASIS_ID';
2788: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2789:
2790: begin