[Home] [Help]
257: --
258: cursor c1 is
259: select null
260: from ff_formulas_f ff
261: ,per_business_groups pbg
262: where ff.formula_id = p_rndg_rl
263: and ff.formula_type_id = -169
264: and pbg.business_group_id = p_business_group_id
265: and nvl(ff.business_group_id, p_business_group_id) =
352: --
353: cursor c1 is
354: select null
355: from ff_formulas_f ff
356: ,per_business_groups pbg
357: where ff.formula_id = p_val_calc_rl
358: and ff.formula_type_id = -507
359: and pbg.business_group_id = p_business_group_id
360: and nvl(ff.business_group_id, p_business_group_id) =
447: --
448: cursor c1 is
449: select null
450: from ff_formulas_f ff
451: ,per_business_groups pbg
452: where ff.formula_id = p_vrbl_rt_add_on_calc_rl
453: and ff.formula_type_id = -529
454: and pbg.business_group_id = p_business_group_id
455: and nvl(ff.business_group_id, p_business_group_id) =
1733: --
1734: cursor c1(p_rule number,p_rule_type_id number) is
1735: select null
1736: from ff_formulas_f ff,
1737: per_business_groups pbg
1738: where ff.formula_id = p_rule
1739: and ff.formula_type_id = p_rule_type_id
1740: and pbg.business_group_id = p_business_group_id
1741: and nvl(ff.business_group_id,p_business_group_id) =
2696: -- Declare cursor
2697: --
2698: cursor csr_leg_code is
2699: select a.legislation_code
2700: from per_business_groups a,
2701: ben_actl_prem_f b
2702: where b.actl_prem_id = p_actl_prem_id
2703: and a.business_group_id = b.business_group_id;
2704: --
2703: and a.business_group_id = b.business_group_id;
2704: --
2705: -- Declare local variables
2706: --
2707: l_legislation_code per_business_groups.legislation_code%TYPE; -- UTF8 varchar2(150);
2708: l_proc varchar2(72) := g_package||'return_legislation_code';
2709: --
2710: begin
2711: --