146: CURSOR get_busgrp_info ( cp_business_group_name varchar2 ) IS
147: SELECT business_group_id
148: ,legislation_code
149: ,currency_code
150: FROM per_business_groups
151: WHERE name = cp_business_group_name;
152:
153: CURSOR get_shd_ele_info ( cp_template_id NUMBER
154: ,cp_element_name VARCHAR2 ) IS
728: cursor cur_leg_code IS
729: SELECT
730: pbg.legislation_code
731: FROM
732: per_business_groups pbg,
733: pay_element_templates pet
734: WHERE
735: pet.template_id = p_template_id AND
736: pet.business_group_id = pbg.business_group_id;