APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_PLIP_F

Line 1544: -- DK Resolve from Table BEN_PLIP_F

1540: ,p_business_group_name => p_business_group_name);
1541: end if;
1542: end;
1543: --
1544: -- DK Resolve from Table BEN_PLIP_F
1545: --
1546: procedure get_dk_frm_cpp (p_business_group_name in VARCHAR2
1547: ,p_source_id in NUMBER
1548: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1550: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID

1546: procedure get_dk_frm_cpp (p_business_group_name in VARCHAR2
1547: ,p_source_id in NUMBER
1548: ,p_resolve_mapping_id out nocopy NUMBER) is
1549: --
1550: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID
1551: --
1552: cursor csr_get_dk_cpp is
1553: select *
1554: from ben_plip_f

Line 1554: from ben_plip_f

1550: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID
1551: --
1552: cursor csr_get_dk_cpp is
1553: select *
1554: from ben_plip_f
1555: where plip_id = p_source_id;
1556:
1557: -- Declare local variables
1558: l_proc varchar2(72) := g_package || 'get_dk_frm_cpp';

Line 1561: l_table_name varchar2(30) := 'BEN_PLIP_F';

1557: -- Declare local variables
1558: l_proc varchar2(72) := g_package || 'get_dk_frm_cpp';
1559: l_row_fetched boolean := FALSE;
1560: l_table_rec csr_get_dk_cpp%rowtype;
1561: l_table_name varchar2(30) := 'BEN_PLIP_F';
1562: l_column_name varchar2(30) := 'PLIP_ID';
1563: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1564: l_pgm_id number;
1565: l_pl_id number;