eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DOWNLOAD_DK dependencies on PAY_ELEMENT_TYPES_F

Line 2355: -- DK Resolve from Table PAY_ELEMENT_TYPES_F

2351: --
2352: end if;
2353: end;
2354: --
2355: -- DK Resolve from Table PAY_ELEMENT_TYPES_F
2356: --
2357: procedure get_dk_frm_pet (p_business_group_name in VARCHAR2
2358: ,p_source_id in NUMBER
2359: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2361: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID

2357: procedure get_dk_frm_pet (p_business_group_name in VARCHAR2
2358: ,p_source_id in NUMBER
2359: ,p_resolve_mapping_id out nocopy NUMBER) is
2360: --
2361: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID
2362: --
2363: cursor csr_get_dk_pet is
2364: select element_name
2365: from pay_element_types_f

Line 2365: from pay_element_types_f

2361: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID
2362: --
2363: cursor csr_get_dk_pet is
2364: select element_name
2365: from pay_element_types_f
2366: where element_type_id = p_source_id;
2367:
2368: -- Declare local variables
2369: l_proc varchar2(72) := g_package || 'get_dk_frm_pet';

Line 2372: l_table_name varchar2(30) := 'PAY_ELEMENT_TYPES_F';

2368: -- Declare local variables
2369: l_proc varchar2(72) := g_package || 'get_dk_frm_pet';
2370: l_row_fetched boolean := FALSE;
2371: l_table_rec csr_get_dk_pet%rowtype;
2372: l_table_name varchar2(30) := 'PAY_ELEMENT_TYPES_F';
2373: l_column_name varchar2(30) := 'ELEMENT_TYPE_ID';
2374: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2375:
2376: begin