332: l_bal_id number := null ;
333: l_proc varchar2(200);
334: cursor c_bal is
335: select balance_type_id
336: from pay_balance_types
337: where balance_name = p_jd_bal_name
338: and legislation_code = 'US';
339: begin
340: l_proc := g_proc||'.get_template_id';
532: ,bf.scale
533: ,et.element_type_id
534: from pay_balance_classifications bc
535: , PAY_BALANCE_FEEDS_F BF
536: , PAY_BALANCE_TYPES BT
537: , PAY_INPUT_VALUES_F IV
538: , PAY_ELEMENT_TYPES_F ET
539: , PAY_ELEMENT_CLASSIFICATIONS EC
540: , HR_LOOKUPS HL
563:
564: -- To get the balance type id
565: cursor c2_balance_type is
566: select balance_type_id
567: from pay_balance_types
568: where business_group_id = p_bg_id
569: and balance_name in (p_ele_name||' Eligible Comp',
570: p_ele_name||' Roth Eligible Comp',
571: p_ele_name||' AT Eligible Comp');