[Home] [Help]
152: ;
153: CURSOR csr_get_class_id
154: (v_element_type_id IN number) IS
155: SELECT classification_id
156: FROM pay_element_classifications
157: WHERE classification_name = p_sub_classification_name
158: AND legislation_code = 'GB'
159: AND business_group_id IS NULL
160: AND parent_classification_id IN