[Home] [Help]
180: and p_enrt_cvg_strt_dt_rl is not null then
181: --
182: -- check if value of formula rule is valid.
183: --
184: if not benutils.formula_exists
185: (p_formula_id => p_enrt_cvg_strt_dt_rl,
186: p_formula_type_id => -29,
187: p_business_group_id => p_business_group_id,
188: p_effective_date => p_effective_date) then
253: and p_enrt_cvg_end_dt_rl is not null then
254: --
255: -- check if value of formula rule is valid.
256: --
257: if not benutils.formula_exists
258: (p_formula_id => p_enrt_cvg_end_dt_rl,
259: p_formula_type_id => -30,
260: p_business_group_id => p_business_group_id,
261: p_effective_date => p_effective_date) then
326: and p_rt_strt_dt_rl is not null then
327: --
328: -- check if value of formula rule is valid.
329: --
330: if not benutils.formula_exists
331: (p_formula_id => p_rt_strt_dt_rl,
332: p_formula_type_id => -66,
333: p_business_group_id => p_business_group_id,
334: p_effective_date => p_effective_date) then
471: and p_rt_end_dt_rl is not null then
472: --
473: -- check if value of formula rule is valid.
474: --
475: if not benutils.formula_exists
476: (p_formula_id => p_rt_end_dt_rl,
477: p_formula_type_id => -67,
478: p_business_group_id => p_business_group_id,
479: p_effective_date => p_effective_date) then
615: and p_enrt_perd_end_dt_rl is not null then
616: --
617: -- check if value of formula rule is valid.
618: --
619: if not benutils.formula_exists
620: (p_formula_id => p_enrt_perd_end_dt_rl,
621: p_formula_type_id => -503,
622: p_business_group_id => p_business_group_id,
623: p_effective_date => p_effective_date) then
759: and p_enrt_perd_strt_dt_rl is not null then
760: --
761: -- check if value of formula rule is valid.
762: --
763: if not benutils.formula_exists
764: (p_formula_id => p_enrt_perd_strt_dt_rl,
765: p_formula_type_id => -504,
766: p_business_group_id => p_business_group_id,
767: p_effective_date => p_effective_date) then