95: order by person_id;
96:
97: cursor get_person_date(p_person_id in number, p_eff_date in date) is
98: select effective_start_date 99: from per_all_people_f 100: where person_id = p_person_id
101: and business_group_id = p_new.business_group_id
102: and p_eff_date between effective_start_date and effective_end_date;
103:
[Home] [Help]