DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_BNFT_PRVDR_POOL_F

Line 8719: ben_bnft_prvdr_pool_f bpp

8715: cursor c_abp(c_acty_base_rt_id number,c_pgm_id number,c_effective_date date ) is
8716: select bpp.bnft_prvdr_pool_id
8717: from
8718: ben_aplcn_to_bnft_pool_f abp,
8719: ben_bnft_prvdr_pool_f bpp
8720: where
8721: abp.acty_base_rt_id = c_acty_base_rt_id
8722: and abp.bnft_prvdr_pool_id = bpp.bnft_prvdr_pool_id
8723: and bpp.pgm_id = c_pgm_id