[Home] [Help]
338: --
339: cursor c1 is
340: select null
341: from ff_formulas_f ff ,
342: per_business_groups pbg
343: where ff.formula_id = p_dflt_enrt_det_rl
344: and ff.formula_type_id = -32 /*default enrollment det */
345: and pbg.business_group_id = p_business_group_id
346: and nvl(ff.business_group_id, p_business_group_id) =
434: --
435: cursor c1 is
436: select null
437: from ff_formulas_f ff ,
438: per_business_groups pbg
439: where ff.formula_id = p_auto_enrt_mthd_rl
440: and ff.formula_type_id = -146 /*default enrollment det */
441: and pbg.business_group_id = p_business_group_id
442: and nvl(ff.business_group_id, p_business_group_id) =
682: --
683: cursor c1 is
684: select null
685: from ff_formulas_f ff ,
686: per_business_groups pbg
687: where ff.formula_id = p_enrt_rl
688: and ff.formula_type_id = -393 /*default enrollment det */
689: and pbg.business_group_id = p_business_group_id
690: and nvl(ff.business_group_id, p_business_group_id) =
776: --
777: cursor c1 is
778: select null
779: from ff_formulas_f ff ,
780: per_business_groups pbg
781: where ff.formula_id = p_dflt_to_asn_pndg_ctfn_rl
782: and ff.formula_type_id = -454
783: and pbg.business_group_id = p_business_group_id
784: and nvl(ff.business_group_id, p_business_group_id) =
872: --
873: cursor c1 is
874: select null
875: from ff_formulas_f ff ,
876: per_business_groups pbg
877: where ff.formula_id = p_mn_cvg_rl
878: and ff.formula_type_id = -164
879: and pbg.business_group_id = p_business_group_id
880: and nvl(ff.business_group_id, p_business_group_id) =
968: --
969: cursor c1 is
970: select null
971: from ff_formulas_f ff ,
972: per_business_groups pbg
973: where ff.formula_id = p_mx_cvg_rl
974: and ff.formula_type_id = -161
975: and pbg.business_group_id = p_business_group_id
976: and nvl(ff.business_group_id, p_business_group_id) =
1064: --
1065: cursor c1 is
1066: select null
1067: from ff_formulas_f ff ,
1068: per_business_groups pbg
1069: where ff.formula_id = p_prort_prtl_yr_cvg_rstrn_rl
1070: and ff.formula_type_id = -166
1071: and pbg.business_group_id = p_business_group_id
1072: and nvl(ff.business_group_id, p_business_group_id) =
2930: --
2931: cursor c1 is
2932: select null
2933: from ff_formulas_f ff ,
2934: per_business_groups pbg
2935: where ff.formula_id = p_enrt_cvg_strt_dt_rl
2936: and ff.formula_type_id = -29
2937: and pbg.business_group_id = p_business_group_id
2938: and nvl(ff.business_group_id, p_business_group_id) =
3023: --
3024: cursor c1 is
3025: select null
3026: from ff_formulas_f ff ,
3027: per_business_groups pbg
3028: where ff.formula_id = p_enrt_cvg_end_dt_rl
3029: and ff.formula_type_id = -30
3030: and pbg.business_group_id = p_business_group_id
3031: and nvl(ff.business_group_id, p_business_group_id) =
3258: --
3259: cursor c1 is
3260: select null
3261: from ff_formulas_f ff ,
3262: per_business_groups pbg
3263: where ff.formula_id = p_rt_strt_dt_rl
3264: and ff.formula_type_id = -66
3265: and pbg.business_group_id = p_business_group_id
3266: and nvl(ff.business_group_id, p_business_group_id) =
3424: --
3425: cursor c1 is
3426: select null
3427: from ff_formulas_f ff ,
3428: per_business_groups pbg
3429: where ff.formula_id = p_rt_end_dt_rl
3430: and ff.formula_type_id = -67
3431: and pbg.business_group_id = p_business_group_id
3432: and nvl(ff.business_group_id, p_business_group_id) =
3519: --
3520: cursor c1 is
3521: select null
3522: from ff_formulas_f ff ,
3523: per_business_groups pbg
3524: where ff.formula_id = p_postelcn_edit_rl
3525: and ff.formula_type_id = -215
3526: and pbg.business_group_id = p_business_group_id
3527: and nvl(ff.business_group_id, p_business_group_id) =
5249: -- Declare cursor
5250: --
5251: cursor csr_leg_code is
5252: select a.legislation_code
5253: from per_business_groups a,
5254: ben_plip_f b
5255: where b.plip_id = p_plip_id
5256: and a.business_group_id = b.business_group_id;
5257: --