APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_OIPLIP_F

Line 1221: -- DK Resolve from Table BEN_OIPLIP_F

1217: ,p_business_group_name => p_business_group_name);
1218: end if;
1219: end;
1220: --
1221: -- DK Resolve from Table BEN_OIPLIP_F
1222: --
1223: procedure get_dk_frm_boi (p_business_group_name in VARCHAR2
1224: ,p_source_id in NUMBER
1225: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1227: -- cursor to Fetch the DK for BEN_OIPLIP_F.OIPLIP_ID

1223: procedure get_dk_frm_boi (p_business_group_name in VARCHAR2
1224: ,p_source_id in NUMBER
1225: ,p_resolve_mapping_id out nocopy NUMBER) is
1226: --
1227: -- cursor to Fetch the DK for BEN_OIPLIP_F.OIPLIP_ID
1228: --
1229: cursor csr_get_dk_boi is
1230: select *
1231: from ben_oiplip_f

Line 1231: from ben_oiplip_f

1227: -- cursor to Fetch the DK for BEN_OIPLIP_F.OIPLIP_ID
1228: --
1229: cursor csr_get_dk_boi is
1230: select *
1231: from ben_oiplip_f
1232: where oiplip_id = p_source_id;
1233:
1234: -- Declare local variables
1235: l_proc varchar2(72) := g_package || 'get_dk_frm_boi';

Line 1238: l_table_name varchar2(30) := 'BEN_OIPLIP_F';

1234: -- Declare local variables
1235: l_proc varchar2(72) := g_package || 'get_dk_frm_boi';
1236: l_row_fetched boolean := FALSE;
1237: l_table_rec csr_get_dk_boi%rowtype;
1238: l_table_name varchar2(30) := 'BEN_OIPLIP_F';
1239: l_column_name varchar2(30) := 'OIPLIP_ID';
1240: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1241: l_oipl_id number;
1242: l_plip_id number;