Line 547: l_bus_group_id per_all_people_f.business_group_id%type;
543: where ppf.person_id = p_person_id
544: and p_effective_date between ppf.effective_start_date
545: and ppf.effective_end_date;
546: 547: l_bus_group_id per_all_people_f.business_group_id%type; 548: -- End of Bug # 7510344
549:
550:
551: BEGIN