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_DETERMINE_RATES dependencies on BEN_ACTY_BASE_RT_F

Line 139: to new column ord_num on ben_acty_base_rt_f

135: 23-May-02 kmahendr 115.46 Added a parameter to ben_determine_acty_base_rt
136: 10-jun-02 pabodla 115.47 LGE : Create rate certifications
137: 28-Sep-02 ikasire 115.49 reverted the changes made in 115.48
138: 11-Oct-02 vsethi 115.50 Rates Sequence no enhancements. Modified to cater
139: to new column ord_num on ben_acty_base_rt_f
140: 28-Oct-02 kmahendr 115.51 Land O Lakes performance fix - cursor c_enrt_rt
141: split into two.
142: 26-Dec-02 rpillay 115.52 NOCOPY changes
143: 13-feb-02 vsethi 115.53 Enclosed all hr_utility debug calls inside if

Line 203: TYPE g_acty_base_rt_id_table IS TABLE OF ben_acty_base_rt_f.acty_base_rt_id%TYPE

199: g_rec benutils.g_batch_rate_rec;
200: --
201: g_debug boolean := hr_utility.debug_enabled;
202: --
203: TYPE g_acty_base_rt_id_table IS TABLE OF ben_acty_base_rt_f.acty_base_rt_id%TYPE
204: INDEX BY BINARY_INTEGER;
205: TYPE g_asn_on_enrt_flag_table IS TABLE OF ben_acty_base_rt_f.asn_on_enrt_flag%TYPE
206: INDEX BY BINARY_INTEGER;
207: --

Line 205: TYPE g_asn_on_enrt_flag_table IS TABLE OF ben_acty_base_rt_f.asn_on_enrt_flag%TYPE

201: g_debug boolean := hr_utility.debug_enabled;
202: --
203: TYPE g_acty_base_rt_id_table IS TABLE OF ben_acty_base_rt_f.acty_base_rt_id%TYPE
204: INDEX BY BINARY_INTEGER;
205: TYPE g_asn_on_enrt_flag_table IS TABLE OF ben_acty_base_rt_f.asn_on_enrt_flag%TYPE
206: INDEX BY BINARY_INTEGER;
207: --
208: -- ----------------------------------------------------------------------------
209: -- |------< ben_rates_old >------|

Line 509: from ben_acty_base_rt_f abr

505: abr.entr_ann_val_flag,
506: abr.currency_det_cd,
507: abr.element_det_rl,
508: abr.element_type_id
509: from ben_acty_base_rt_f abr
510: where abr.acty_base_rt_id = p_acty_base_rt_id
511: and p_effective_date between abr.effective_start_date and abr.effective_end_date;
512:
513: l_env ben_env_object.g_global_env_rec_type;

Line 732: -- from ben_acty_base_rt_f table.

728: l_ordr_num(i) := NULL;
729: l_iss_val(i) := NULL;
730: --
731: -- Fetch acty_typ_cd and other not-null values
732: -- from ben_acty_base_rt_f table.
733: open c_abr(p_acty_base_rt_id_table(i));
734: fetch c_abr into l_abr;
735: if c_abr%FOUND then
736: l_acty_typ_cd(i) := l_abr.acty_typ_cd;

Line 1818: FROM ben_acty_base_rt_f abr

1814: CURSOR c_abr_oiplip(
1815: c_effective_date DATE) IS
1816: SELECT abr.acty_base_rt_id,
1817: abr.asn_on_enrt_flag
1818: FROM ben_acty_base_rt_f abr
1819: WHERE abr.oiplip_id = l_oiplip_id
1820: AND abr.rt_usg_cd <> 'FLXCR'
1821: AND abr.acty_base_rt_stat_cd = 'A'
1822: AND c_effective_date BETWEEN abr.effective_start_date

Line 1829: FROM ben_acty_base_rt_f abr

1825: CURSOR c_abr_oipl(
1826: c_effective_date DATE) IS
1827: SELECT abr.acty_base_rt_id,
1828: abr.asn_on_enrt_flag
1829: FROM ben_acty_base_rt_f abr
1830: WHERE abr.acty_base_rt_stat_cd = 'A'
1831: AND abr.oipl_id = l_oipl_id
1832: AND abr.rt_usg_cd <> 'FLXCR'
1833: AND c_effective_date BETWEEN abr.effective_start_date

Line 1841: FROM ben_acty_base_rt_f abr

1837: CURSOR c_abr_opt(
1838: c_effective_date DATE) IS
1839: SELECT abr.acty_base_rt_id,
1840: abr.asn_on_enrt_flag
1841: FROM ben_acty_base_rt_f abr
1842: WHERE abr.acty_base_rt_stat_cd = 'A'
1843: AND abr.opt_id = l_opt_id
1844: AND abr.rt_usg_cd <> 'FLXCR'
1845: AND c_effective_date BETWEEN abr.effective_start_date

Line 1853: FROM ben_acty_base_rt_f abr

1849: CURSOR c_abr_plip(
1850: c_effective_date DATE) IS
1851: SELECT abr.acty_base_rt_id,
1852: abr.asn_on_enrt_flag
1853: FROM ben_acty_base_rt_f abr
1854: WHERE abr.acty_base_rt_stat_cd = 'A'
1855: AND abr.plip_id = l_plip_id
1856: AND abr.rt_usg_cd <> 'FLXCR'
1857: AND abr.cmbn_plip_id IS NULL

Line 1865: FROM ben_acty_base_rt_f abr

1861: CURSOR c_abr_pl(
1862: c_effective_date DATE) IS
1863: SELECT abr.acty_base_rt_id,
1864: abr.asn_on_enrt_flag
1865: FROM ben_acty_base_rt_f abr
1866: WHERE abr.acty_base_rt_stat_cd = 'A'
1867: AND abr.pl_id = l_pl_id
1868: AND abr.rt_usg_cd <> 'FLXCR'
1869: AND c_effective_date BETWEEN abr.effective_start_date

Line 1876: FROM ben_acty_base_rt_f abr

1872: CURSOR c_abr_pgm(
1873: c_effective_date DATE) IS
1874: SELECT abr.acty_base_rt_id,
1875: abr.asn_on_enrt_flag
1876: FROM ben_acty_base_rt_f abr
1877: WHERE abr.acty_base_rt_stat_cd = 'A'
1878: AND abr.pgm_id = l_pgm_id
1879: AND c_effective_date BETWEEN abr.effective_start_date
1880: AND abr.effective_end_date

Line 1886: FROM ben_acty_base_rt_f abr

1882: CURSOR c_abr_ptip(
1883: c_effective_date DATE) IS
1884: SELECT abr.acty_base_rt_id,
1885: abr.asn_on_enrt_flag
1886: FROM ben_acty_base_rt_f abr
1887: WHERE abr.acty_base_rt_stat_cd = 'A'
1888: AND abr.ptip_id = l_ptip_id
1889: AND abr.cmbn_ptip_id IS NULL
1890: AND abr.cmbn_ptip_opt_id IS NULL

Line 1898: FROM ben_acty_base_rt_f abr

1894: CURSOR c_abr_cmbn_ptip(
1895: c_effective_date DATE) IS
1896: SELECT abr.acty_base_rt_id,
1897: abr.asn_on_enrt_flag
1898: FROM ben_acty_base_rt_f abr
1899: WHERE abr.acty_base_rt_stat_cd = 'A'
1900: AND abr.cmbn_ptip_id = l_cmbn_ptip_id
1901: AND c_effective_date BETWEEN abr.effective_start_date
1902: AND abr.effective_end_date

Line 1910: FROM ben_acty_base_rt_f abr

1906: CURSOR c_abr_flx_plip(
1907: c_effective_date DATE) IS
1908: SELECT abr.acty_base_rt_id,
1909: abr.asn_on_enrt_flag
1910: FROM ben_acty_base_rt_f abr
1911: WHERE abr.acty_base_rt_stat_cd = 'A'
1912: AND abr.plip_id = l_plip_id
1913: AND abr.rt_usg_cd = 'FLXCR'
1914: AND abr.cmbn_plip_id IS NULL

Line 1922: FROM ben_acty_base_rt_f abr

1918: CURSOR c_abr_cmbn_plip(
1919: c_effective_date DATE) IS
1920: SELECT abr.acty_base_rt_id,
1921: abr.asn_on_enrt_flag
1922: FROM ben_acty_base_rt_f abr
1923: WHERE abr.acty_base_rt_stat_cd = 'A'
1924: AND abr.cmbn_plip_id = l_cmbn_plip_id
1925: AND c_effective_date BETWEEN abr.effective_start_date
1926: AND abr.effective_end_date

Line 1933: FROM ben_acty_base_rt_f abr

1929: CURSOR c_abr_flx_oiplip(
1930: c_effective_date DATE) IS
1931: SELECT abr.acty_base_rt_id,
1932: abr.asn_on_enrt_flag
1933: FROM ben_acty_base_rt_f abr
1934: WHERE abr.oiplip_id = l_oiplip_id
1935: AND abr.rt_usg_cd = 'FLXCR'
1936: AND abr.acty_base_rt_stat_cd = 'A'
1937: AND c_effective_date BETWEEN abr.effective_start_date

Line 1944: FROM ben_acty_base_rt_f abr

1940: CURSOR c_abr_cmbn_ptip_opt(
1941: c_effective_date DATE) IS
1942: SELECT abr.acty_base_rt_id,
1943: abr.asn_on_enrt_flag
1944: FROM ben_acty_base_rt_f abr
1945: WHERE abr.acty_base_rt_stat_cd = 'A'
1946: AND abr.cmbn_ptip_opt_id = l_cmbn_ptip_opt_id
1947: AND c_effective_date BETWEEN abr.effective_start_date
1948: AND abr.effective_end_date

Line 2022: FROM ben_acty_base_rt_f abr

2018: p_pl_id number,
2019: p_opt_id number,
2020: p_business_group_id number) is
2021: SELECT *
2022: FROM ben_acty_base_rt_f abr
2023: WHERE abr.business_group_id = p_business_group_id
2024: AND Nvl(abr.context_pgm_id,-1) = Nvl(p_pgm_id,-1)
2025: AND Nvl(abr.context_pl_id,-1) = Nvl(p_pl_id,-1)
2026: AND Nvl(abr.context_opt_id,-1) = Nvl(p_opt_id,-1);