7: -- Hand coded
8: --
9: -- plan participating eligibility profile by plan
10: --
11: g_cache_plnelp_lookup ben_cache.g_cache_lookup_table;
12: g_cache_plnelp_inst ben_cel_cache.g_cache_cepelp_instor;
13: --
14: -- program participating eligibility profile by program
15: --
12: g_cache_plnelp_inst ben_cel_cache.g_cache_cepelp_instor;
13: --
14: -- program participating eligibility profile by program
15: --
16: g_cache_pgmelp_lookup ben_cache.g_cache_lookup_table;
17: g_cache_pgmelp_inst ben_cel_cache.g_cache_cepelp_instor;
18: --
19: -- oipl participating eligibility profile by oipl
20: --
17: g_cache_pgmelp_inst ben_cel_cache.g_cache_cepelp_instor;
18: --
19: -- oipl participating eligibility profile by oipl
20: --
21: g_cache_copelp_lookup ben_cache.g_cache_lookup_table;
22: g_cache_copelp_inst ben_cel_cache.g_cache_cepelp_instor;
23: --
24: -- plip participating eligibility profile by plip
25: --
22: g_cache_copelp_inst ben_cel_cache.g_cache_cepelp_instor;
23: --
24: -- plip participating eligibility profile by plip
25: --
26: g_cache_cppelp_lookup ben_cache.g_cache_lookup_table;
27: g_cache_cppelp_inst ben_cel_cache.g_cache_cepelp_instor;
28: --
29: -- ptip participating eligibility profile by ptip
30: --
27: g_cache_cppelp_inst ben_cel_cache.g_cache_cepelp_instor;
28: --
29: -- ptip participating eligibility profile by ptip
30: --
31: g_cache_ctpelp_lookup ben_cache.g_cache_lookup_table;
32: g_cache_ctpelp_inst ben_cel_cache.g_cache_cepelp_instor;
33: --
34: procedure plnelp_writecache
35: (p_effective_date in date,