152:
153: CURSOR get_template_id ( cp_legislation_code varchar2
154: ,cp_template_name varchar2) IS
155: SELECT template_id
156: FROM pay_element_templates
157: WHERE legislation_code = cp_legislation_code
158: AND template_name = cp_template_name;
159:
160: CURSOR get_busgrp_info ( cp_business_group_name varchar2 ) IS
848: SELECT
849: pbg.legislation_code
850: FROM
851: per_business_groups pbg,
852: pay_element_templates pet
853: WHERE
854: pet.template_id = p_template_id AND
855: pet.business_group_id = pbg.business_group_id;
856: