158: and pet.classification_id = pec.classification_id;
159:
160: cursor c_legislation_code(cp_business_group_id in number) is
161: select legislation_code
162: from per_business_groups
163: where business_group_id = cp_business_group_id;
164:
165: cursor c_element_set(cp_element_type_id in number
166: ,cp_classification_id in number
348: order by pet.effective_start_date desc;
349:
350: cursor c_legislation_code(cp_business_group_id in number) is
351: select legislation_code
352: from per_business_groups
353: where business_group_id = cp_business_group_id;
354:
355: cursor c_element_set(cp_element_type_id in number
356: ,cp_classification_id in number