DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_ENRT_RT_CTFN

Line 428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;

424: l_enrt_rt_id_tab l_number_15_table_type; -- 2897152
425:
426: --
427: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;
429: l_old_val NUMBER;
430: l_dummy varchar2(1);
431: --
432: cursor c_enrt_rt_id is

Line 483: from ben_enrt_rt_ctfn erc

479: --
480: cursor c_enrt_ctfn_exists (p_enrt_rt_id number,
481: p_enrt_ctfn_typ_cd varchar2) is
482: select null
483: from ben_enrt_rt_ctfn erc
484: where erc.enrt_rt_id = p_enrt_rt_id
485: and erc.enrt_ctfn_typ_cd = p_enrt_ctfn_typ_cd;
486: --
487: -- 2897152

Line 1663: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

1659: -- bug#4126093
1660: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1661: fetch c_enrt_ctfn_exists into l_dummy;
1662: if c_enrt_ctfn_exists%notfound then
1663: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1664: (p_validate => false
1665: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1666: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1667: ,p_rqd_flag => l_enrt_ctfn.rqd_flag

Line 1690: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

1686: --
1687: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1688: fetch c_enrt_ctfn_exists into l_dummy;
1689: if c_enrt_ctfn_exists%notfound then
1690: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1691: (p_validate => false
1692: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1693: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1694: ,p_rqd_flag => l_enrt_ctfn.rqd_flag