eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_YR_PERD

Line 1861: -- DK Resolve from Table BEN_YR_PERD

1857: --
1858: end if;
1859: end;
1860: --
1861: -- DK Resolve from Table BEN_YR_PERD
1862: --
1863: procedure get_dk_frm_yrp (p_business_group_name in VARCHAR2
1864: ,p_source_id in NUMBER
1865: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1867: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID

1863: procedure get_dk_frm_yrp (p_business_group_name in VARCHAR2
1864: ,p_source_id in NUMBER
1865: ,p_resolve_mapping_id out nocopy NUMBER) is
1866: --
1867: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID
1868: --
1869: cursor csr_get_dk_yrp is
1870: select to_char(END_DATE,'YYYYMMDD:HH24:mi:ss')||'-'||to_char(START_DATE,'DD-MON-YYYY')||'-'||PERD_TYP_CD name
1871: from ben_yr_perd

Line 1871: from ben_yr_perd

1867: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID
1868: --
1869: cursor csr_get_dk_yrp is
1870: select to_char(END_DATE,'YYYYMMDD:HH24:mi:ss')||'-'||to_char(START_DATE,'DD-MON-YYYY')||'-'||PERD_TYP_CD name
1871: from ben_yr_perd
1872: where yr_perd_id = p_source_id;
1873:
1874: -- Declare local variables
1875: l_proc varchar2(72) := g_package || 'get_dk_frm_yrp';

Line 1878: l_table_name varchar2(30) := 'BEN_YR_PERD';

1874: -- Declare local variables
1875: l_proc varchar2(72) := g_package || 'get_dk_frm_yrp';
1876: l_row_fetched boolean := FALSE;
1877: l_table_rec csr_get_dk_yrp%rowtype;
1878: l_table_name varchar2(30) := 'BEN_YR_PERD';
1879: l_column_name varchar2(30) := 'YR_PERD_ID';
1880: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1881:
1882: begin