APPS.BEN_DM_DOWNLOAD_DK dependencies on PAY_INPUT_VALUES_F

Line 2428: -- DK Resolve from Table PAY_INPUT_VALUES_F

2424:
2425: end if;
2426: end;
2427: --
2428: -- DK Resolve from Table PAY_INPUT_VALUES_F
2429: --
2430: procedure get_dk_frm_ipv (p_business_group_name in VARCHAR2
2431: ,p_source_id in NUMBER
2432: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2434: -- cursor to Fetch the DK for PAY_INPUT_VALUES_F.INPUT_VALUE_ID

2430: procedure get_dk_frm_ipv (p_business_group_name in VARCHAR2
2431: ,p_source_id in NUMBER
2432: ,p_resolve_mapping_id out nocopy NUMBER) is
2433: --
2434: -- cursor to Fetch the DK for PAY_INPUT_VALUES_F.INPUT_VALUE_ID
2435: --
2436: cursor csr_get_dk_ipv is
2437: select *
2438: from pay_input_values_f

Line 2438: from pay_input_values_f

2434: -- cursor to Fetch the DK for PAY_INPUT_VALUES_F.INPUT_VALUE_ID
2435: --
2436: cursor csr_get_dk_ipv is
2437: select *
2438: from pay_input_values_f
2439: where input_value_id = p_source_id;
2440:
2441: -- Declare local variables
2442: l_proc varchar2(72) := g_package || 'get_dk_frm_ipv';

Line 2445: l_table_name varchar2(30) := 'PAY_INPUT_VALUES_F';

2441: -- Declare local variables
2442: l_proc varchar2(72) := g_package || 'get_dk_frm_ipv';
2443: l_row_fetched boolean := FALSE;
2444: l_table_rec csr_get_dk_ipv%rowtype;
2445: l_table_name varchar2(30) := 'PAY_INPUT_VALUES_F';
2446: l_column_name varchar2(30) := 'INPUT_VALUE_ID';
2447: l_element_type_id number;
2448: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2449: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;