DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_BNFT_PRVDR_POOL_F

Line 9525: ben_bnft_prvdr_pool_f bpp

9521: cursor c_abp(c_acty_base_rt_id number,c_pgm_id number,c_effective_date date ) is
9522: select bpp.bnft_prvdr_pool_id
9523: from
9524: ben_aplcn_to_bnft_pool_f abp,
9525: ben_bnft_prvdr_pool_f bpp
9526: where
9527: abp.acty_base_rt_id = c_acty_base_rt_id
9528: and abp.bnft_prvdr_pool_id = bpp.bnft_prvdr_pool_id
9529: and bpp.pgm_id = c_pgm_id