519: and gre.business_group_id = p_business_group_id;
520: --
521: cursor c6 (p_business_group_id number) is
522: select null 523: from ben_pl_f pln 524: where pln.pl_id = l_number
525: and p_effective_date between pln.effective_start_date
526: and pln.effective_end_date
527: and pln.business_group_id = p_business_group_id;