326:
327: CURSOR get_sub_classifications (cp_element_type_id NUMBER) IS
328: SELECT pec.classification_name
329: FROM pay_element_classifications pec,
330: pay_sub_classification_rules pscr
331: WHERE pec.classification_id = pscr.classification_id
332: AND pscr.element_type_id = cp_element_type_id
333: AND pscr.business_group_id IS NOT NULL
334: AND pscr.legislation_code IS NULL