APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_ENRT_BNFT

Line 1520: from ben_enrt_bnft enb

1516: ,enb.ordr_num
1517: ,enb.dflt_val
1518: ,enb.comp_lvl_fctr_id
1519: ,enb.enrt_bnft_id
1520: from ben_enrt_bnft enb
1521: where enb.elig_per_elctbl_chc_id = p_bckdt_epe_id ;
1522: --
1523: cursor c_curr_enb is
1524: select enb.dflt_flag

Line 1538: from ben_enrt_bnft enb

1534: ,enb.ordr_num
1535: ,enb.dflt_val
1536: ,enb.comp_lvl_fctr_id
1537: ,enb.enrt_bnft_id
1538: from ben_enrt_bnft enb
1539: where enb.elig_per_elctbl_chc_id = p_curr_epe_id ;
1540: --
1541: TYPE l_bckdt_enb_rec is TABLE OF c_bckdt_enb%rowtype
1542: INDEX BY BINARY_INTEGER;

Line 1558: from ben_enrt_bnft enb

1554: --
1555: hr_utility.set_location ('Entering '||l_proc,10);
1556: --
1557: select count(*) into l_bckdt_enb_count
1558: from ben_enrt_bnft enb
1559: where enb.elig_per_elctbl_chc_id = p_bckdt_epe_id
1560: and enb.business_group_id = p_business_group_id;
1561: /*
1562: l_bckdt_enb_table.delete;

Line 1873: -- ben_enrt_bnft

1869: --
1870: -- ben_elig_cvrd_dpnt_f
1871: -- ben_prtt_enrt_actn_f
1872: -- ben_elig_per_elctbl_chc -- 9999 done
1873: -- ben_enrt_bnft
1874: -- ben_enrt_rt
1875: -- ben_elctbl_chc_ctfn
1876: --
1877: cursor c_bckdt_epe_cnt is

Line 2259: -- ben_enrt_bnft

2255: --
2256: -- ben_elig_cvrd_dpnt_f
2257: -- ben_prtt_enrt_actn_f
2258: -- ben_elig_per_elctbl_chc
2259: -- ben_enrt_bnft
2260: -- ben_enrt_rt
2261: -- ben_elctbl_chc_ctfn
2262: --
2263: cursor c_bckdt_epe_cnt is

Line 5904: from ben_enrt_bnft enb

5900: enb.dflt_val,
5901: enb.val,
5902: enb.dflt_flag,
5903: enb.cvg_mlt_cd --Bug 3315323
5904: from ben_enrt_bnft enb
5905: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
5906: -- Bug 2526994 we need take the right one
5907: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
5908: and enb.ordr_num = cp_ordr_num ; --This is more accurate

Line 7672: from ben_enrt_bnft enb

7668: enb.dflt_val,
7669: enb.val,
7670: enb.dflt_flag,
7671: enb.cvg_mlt_cd --Bug 3315323
7672: from ben_enrt_bnft enb
7673: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
7674: -- Bug 2526994 we need take the right one
7675: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
7676: and enb.ordr_num = cp_ordr_num ; --This is more accurate

Line 8687: ben_enrt_bnft enb

8683: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,
8684: v_acty_base_rt_id number) is
8685: select ecr.enrt_bnft_id
8686: from ben_enrt_rt ecr,
8687: ben_enrt_bnft enb
8688: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
8689: and enb.ordr_num > 0 --9999 Need to check this
8690: and ecr.enrt_bnft_id = enb.enrt_bnft_id
8691: and ecr.acty_base_rt_id = v_acty_base_rt_id ;

Line 10128: from ben_enrt_bnft enb

10124: enb.dflt_flag,
10125: enb.object_version_number,
10126: enb.prtt_enrt_rslt_id,
10127: enb.cvg_mlt_cd --Bug 3315323
10128: from ben_enrt_bnft enb
10129: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
10130: -- Bug 2526994 we need take the right one
10131: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
10132: and enb.ordr_num = cp_ordr_num ; --This is more accurate

Line 10647: ben_enrt_bnft_api.update_enrt_bnft

10643: end if ;
10644:
10645: if l_bnft_rec.prtt_enrt_rslt_id is not null then
10646: l_object_version_number := l_bnft_rec.object_version_number ;
10647: ben_enrt_bnft_api.update_enrt_bnft
10648: (p_enrt_bnft_id => l_bnft_rec.enrt_bnft_id
10649: ,p_effective_date => p_effective_date
10650: ,p_object_version_number => l_object_version_number
10651: ,p_business_group_id => p_business_group_id