390: l_ele_category varchar2(30);
391:
392: cursor c4 is
393: select template_id,base_processing_priority
394: from pay_element_templates
395: where template_name = l_template_name
396: and legislation_code = p_legislation_code
397: and template_type = 'T'
398: and business_group_id is null;
2212: l_proc varchar2(200);
2213: --
2214: cursor c1 is
2215: select template_id
2216: from pay_element_templates
2217: where base_name = p_ele_name
2218: and business_group_id = p_business_group_id
2219: and template_type = 'U';
2220: --