APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_PTIP_F

Line 1779: -- DK Resolve from Table BEN_PTIP_F

1775: ,p_business_group_name => p_business_group_name);
1776: end if;
1777: end;
1778: --
1779: -- DK Resolve from Table BEN_PTIP_F
1780: --
1781: procedure get_dk_frm_ctp (p_business_group_name in VARCHAR2
1782: ,p_source_id in NUMBER
1783: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1785: -- cursor to Fetch the DK for BEN_PTIP_F.PTIP_ID

1781: procedure get_dk_frm_ctp (p_business_group_name in VARCHAR2
1782: ,p_source_id in NUMBER
1783: ,p_resolve_mapping_id out nocopy NUMBER) is
1784: --
1785: -- cursor to Fetch the DK for BEN_PTIP_F.PTIP_ID
1786: --
1787: cursor csr_get_dk_ctp is
1788: select *
1789: from ben_ptip_f

Line 1789: from ben_ptip_f

1785: -- cursor to Fetch the DK for BEN_PTIP_F.PTIP_ID
1786: --
1787: cursor csr_get_dk_ctp is
1788: select *
1789: from ben_ptip_f
1790: where ptip_id = p_source_id;
1791:
1792: -- select 'dk' name
1793:

Line 1798: l_table_name varchar2(30) := 'BEN_PTIP_F';

1794: -- Declare local variables
1795: l_proc varchar2(72) := g_package || 'get_dk_frm_ctp';
1796: l_row_fetched boolean := FALSE;
1797: l_table_rec csr_get_dk_ctp%rowtype;
1798: l_table_name varchar2(30) := 'BEN_PTIP_F';
1799: l_column_name varchar2(30) := 'PTIP_ID';
1800: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1801: l_pgm_id number;
1802: l_pl_typ_id number;