APPS.BEN_PROVIDER_POOLS dependencies on BEN_BNFT_PRVDR_POOL_F

Line 289: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,

285: bpp.pgm_id,
286: ptip.pl_typ_id,
287: nvl(plip.pl_id, plip2.pl_id) pl_id,
288: oipl.opt_id
289: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
290: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
291: where p_effective_date between
292: bpp.effective_start_date and
293: bpp.effective_end_date and

Line 985: from ben_bnft_prvdr_pool_f bpp

981: l_pgm_id number;
982: --
983: cursor c_bnft_pool is
984: select bpp.pgm_id
985: from ben_bnft_prvdr_pool_f bpp
986: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
987: and p_effective_date between bpp.effective_start_date
988: and bpp.effective_end_date;
989: --

Line 2984: from ben_bnft_prvdr_pool_f bpp

2980: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2981: --
2982: cursor c_bnft_pool is
2983: select bpp.pgm_id
2984: from ben_bnft_prvdr_pool_f bpp
2985: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
2986: and p_effective_date between bpp.effective_start_date
2987: and bpp.effective_end_date;
2988:

Line 3905: from ben_bnft_prvdr_pool_f bpp

3901: l_proc varchar2(72) := g_package||'.validate_rollover_val';
3902: --
3903: cursor c_pool_info is
3904: select bpp.*
3905: from ben_bnft_prvdr_pool_f bpp
3906: where p_effective_date between
3907: bpp.effective_start_date and
3908: bpp.effective_end_date and
3909: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 4118: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula

4114: ben_enrt_rt ecr1,
4115: ben_enrt_rt ecr2,
4116: ben_enrt_bnft enb,
4117: ben_prtt_enrt_rslt_f pen,
4118: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
4119: where pil.per_in_ler_id=p_per_in_ler_id and
4120: pil.business_group_id=p_business_group_id and
4121: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and
4122: pil.per_in_ler_id=epe.per_in_ler_id and

Line 4391: from ben_bnft_prvdr_pool_f bpp

4387: l_ledger_totals c_ledger_totals%rowtype;
4388:
4389: cursor c_pool_info is
4390: select bpp.*
4391: from ben_bnft_prvdr_pool_f bpp
4392: where p_effective_date between
4393: bpp.effective_start_date and
4394: bpp.effective_end_date and
4395: bpp.bnft_prvdr_pool_id=l_ledger_totals.bnft_prvdr_pool_id and

Line 5963: from ben_bnft_prvdr_pool_f bpp

5959: bpp.val_rndg_cd,
5960: bpp.val_rndg_rl,
5961: bpp.auto_alct_excs_flag,
5962: bpp.uses_net_crs_mthd_flag
5963: from ben_bnft_prvdr_pool_f bpp
5964: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5965: and bpp.business_group_id = p_business_group_id
5966: and p_effective_date between
5967: bpp.effective_start_date and bpp.effective_end_date;

Line 6670: ben_bnft_prvdr_pool_f bpp

6666: bpp.uses_net_crs_mthd_flag
6667: from ben_prtt_enrt_rslt_f flex_pen,
6668: ben_bnft_prvdd_ldgr_f bpl,
6669: ben_per_in_ler pil,
6670: ben_bnft_prvdr_pool_f bpp
6671: where flex_pen.person_id = p_person_id
6672: and flex_pen.pgm_id = p_pgm_id
6673: and flex_pen.prtt_enrt_rslt_stat_cd is null
6674: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot