APPS.BEN_DM_DOWNLOAD_DK dependencies on PAY_ELEMENT_LINKS_F

Line 2501: -- DK Resolve from Table PAY_ELEMENT_LINKS_F

2497: --
2498: end if;
2499: end;
2500: --
2501: -- DK Resolve from Table PAY_ELEMENT_LINKS_F
2502: --
2503: procedure get_dk_frm_pll (p_business_group_name in VARCHAR2
2504: ,p_source_id in NUMBER
2505: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2507: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID

2503: procedure get_dk_frm_pll (p_business_group_name in VARCHAR2
2504: ,p_source_id in NUMBER
2505: ,p_resolve_mapping_id out nocopy NUMBER) is
2506: --
2507: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID
2508: --
2509: cursor csr_get_dk_pll is
2510: select *
2511: from pay_element_links_f

Line 2511: from pay_element_links_f

2507: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID
2508: --
2509: cursor csr_get_dk_pll is
2510: select *
2511: from pay_element_links_f
2512: where element_link_id = p_source_id;
2513:
2514: -- Declare local variables
2515: l_proc varchar2(72) := g_package || 'get_dk_frm_pll';

Line 2518: l_table_name varchar2(30) := 'PAY_ELEMENT_LINKS_F';

2514: -- Declare local variables
2515: l_proc varchar2(72) := g_package || 'get_dk_frm_pll';
2516: l_row_fetched boolean := FALSE;
2517: l_table_rec csr_get_dk_pll%rowtype;
2518: l_table_name varchar2(30) := 'PAY_ELEMENT_LINKS_F';
2519: l_column_name varchar2(30) := 'ELEMENT_LINK_ID';
2520: l_element_type_id number;
2521: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2522: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;