144: where element_type_id = cp_element_type_id;
145:
146: cursor c_legislation_code(cp_business_group_id in number) is
147: select legislation_code
148: from per_business_groups
149: where business_group_id = cp_business_group_id;
150:
151: cursor c_element_set(cp_element_type_id in number
152: ,cp_classification_id in number
265: order by pet.effective_start_date desc;
266:
267: cursor c_legislation_code(cp_business_group_id in number) is
268: select legislation_code
269: from per_business_groups
270: where business_group_id = cp_business_group_id;
271:
272: cursor c_element_set(cp_element_type_id in number
273: ,cp_classification_id in number