APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_LER_F

Line 1148: -- DK Resolve from Table BEN_LER_F

1144: --
1145: end if;
1146: end;
1147: --
1148: -- DK Resolve from Table BEN_LER_F
1149: --
1150: procedure get_dk_frm_ler (p_business_group_name in VARCHAR2
1151: ,p_source_id in NUMBER
1152: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1154: -- cursor to Fetch the DK for BEN_LER_F.LER_ID

1150: procedure get_dk_frm_ler (p_business_group_name in VARCHAR2
1151: ,p_source_id in NUMBER
1152: ,p_resolve_mapping_id out nocopy NUMBER) is
1153: --
1154: -- cursor to Fetch the DK for BEN_LER_F.LER_ID
1155: --
1156: cursor csr_get_dk_ler is
1157: select name
1158: from ben_ler_f

Line 1158: from ben_ler_f

1154: -- cursor to Fetch the DK for BEN_LER_F.LER_ID
1155: --
1156: cursor csr_get_dk_ler is
1157: select name
1158: from ben_ler_f
1159: where ler_id = p_source_id;
1160:
1161: -- Declare local variables
1162: l_proc varchar2(72) := g_package || 'get_dk_frm_ler';

Line 1165: l_table_name varchar2(30) := 'BEN_LER_F';

1161: -- Declare local variables
1162: l_proc varchar2(72) := g_package || 'get_dk_frm_ler';
1163: l_row_fetched boolean := FALSE;
1164: l_table_rec csr_get_dk_ler%rowtype;
1165: l_table_name varchar2(30) := 'BEN_LER_F';
1166: l_column_name varchar2(30) := 'LER_ID';
1167: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1168:
1169: begin