APPS.BEN_PROVIDER_POOLS dependencies on BEN_BNFT_PRVDR_POOL_F

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

303: bpp.pgm_id,
304: ptip.pl_typ_id,
305: nvl(plip.pl_id, plip2.pl_id) pl_id,
306: oipl.opt_id
307: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
308: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
309: where p_effective_date between
310: bpp.effective_start_date and
311: bpp.effective_end_date and

Line 1003: from ben_bnft_prvdr_pool_f bpp

999: l_pgm_id number;
1000: --
1001: cursor c_bnft_pool is
1002: select bpp.pgm_id
1003: from ben_bnft_prvdr_pool_f bpp
1004: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
1005: and p_effective_date between bpp.effective_start_date
1006: and bpp.effective_end_date;
1007: --

Line 3163: from ben_bnft_prvdr_pool_f bpp

3159: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
3160: --
3161: cursor c_bnft_pool is
3162: select bpp.pgm_id
3163: from ben_bnft_prvdr_pool_f bpp
3164: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
3165: and p_effective_date between bpp.effective_start_date
3166: and bpp.effective_end_date;
3167:

Line 4084: from ben_bnft_prvdr_pool_f bpp

4080: l_proc varchar2(72) := g_package||'.validate_rollover_val';
4081: --
4082: cursor c_pool_info is
4083: select bpp.*
4084: from ben_bnft_prvdr_pool_f bpp
4085: where p_effective_date between
4086: bpp.effective_start_date and
4087: bpp.effective_end_date and
4088: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

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

4293: ben_enrt_rt ecr1,
4294: ben_enrt_rt ecr2,
4295: ben_enrt_bnft enb,
4296: ben_prtt_enrt_rslt_f pen,
4297: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
4298: where pil.per_in_ler_id=p_per_in_ler_id and
4299: pil.business_group_id=p_business_group_id and
4300: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and
4301: pil.per_in_ler_id=epe.per_in_ler_id and

Line 4570: from ben_bnft_prvdr_pool_f bpp

4566: l_ledger_totals c_ledger_totals%rowtype;
4567:
4568: cursor c_pool_info is
4569: select bpp.*
4570: from ben_bnft_prvdr_pool_f bpp
4571: where p_effective_date between
4572: bpp.effective_start_date and
4573: bpp.effective_end_date and
4574: bpp.bnft_prvdr_pool_id=l_ledger_totals.bnft_prvdr_pool_id and

Line 6140: from ben_bnft_prvdr_pool_f bpp

6136: bpp.val_rndg_cd,
6137: bpp.val_rndg_rl,
6138: bpp.auto_alct_excs_flag,
6139: bpp.uses_net_crs_mthd_flag
6140: from ben_bnft_prvdr_pool_f bpp
6141: where bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
6142: and bpp.business_group_id = p_business_group_id
6143: and p_effective_date between
6144: bpp.effective_start_date and bpp.effective_end_date;

Line 6847: ben_bnft_prvdr_pool_f bpp

6843: bpp.uses_net_crs_mthd_flag
6844: from ben_prtt_enrt_rslt_f flex_pen,
6845: ben_bnft_prvdd_ldgr_f bpl,
6846: ben_per_in_ler pil,
6847: ben_bnft_prvdr_pool_f bpp
6848: where flex_pen.person_id = p_person_id
6849: and flex_pen.pgm_id = p_pgm_id
6850: and flex_pen.prtt_enrt_rslt_stat_cd is null
6851: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot