APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_PL_TYP_F

Line 1707: -- DK Resolve from Table BEN_PL_TYP_F

1703: ,p_business_group_name => p_business_group_name);
1704: end if;
1705: end;
1706: --
1707: -- DK Resolve from Table BEN_PL_TYP_F
1708: --
1709: procedure get_dk_frm_ptp (p_business_group_name in VARCHAR2
1710: ,p_source_id in NUMBER
1711: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1713: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID

1709: procedure get_dk_frm_ptp (p_business_group_name in VARCHAR2
1710: ,p_source_id in NUMBER
1711: ,p_resolve_mapping_id out nocopy NUMBER) is
1712: --
1713: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID
1714: --
1715: cursor csr_get_dk_ptp is
1716: select name
1717: from ben_pl_typ_f

Line 1717: from ben_pl_typ_f

1713: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID
1714: --
1715: cursor csr_get_dk_ptp is
1716: select name
1717: from ben_pl_typ_f
1718: where pl_typ_id = p_source_id;
1719:
1720: -- Declare local variables
1721: l_proc varchar2(72) := g_package || 'get_dk_frm_ptp';

Line 1724: l_table_name varchar2(30) := 'BEN_PL_TYP_F';

1720: -- Declare local variables
1721: l_proc varchar2(72) := g_package || 'get_dk_frm_ptp';
1722: l_row_fetched boolean := FALSE;
1723: l_table_rec csr_get_dk_ptp%rowtype;
1724: l_table_name varchar2(30) := 'BEN_PL_TYP_F';
1725: l_column_name varchar2(30) := 'PL_TYP_ID';
1726: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1727:
1728: begin