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
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
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';
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