APPS.BEN_DETERMINE_RATES dependencies on BEN_ENRT_RT_CTFN

Line 426: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;

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

Line 481: from ben_enrt_rt_ctfn erc

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

Line 1661: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

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

Line 1688: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

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