2705: CURSOR c_get_balance_name
2706: IS
2707: SELECT balance_type_id ,pbd.balance_dimension_id
2708: FROM pay_balance_types pbt
2709: ,pay_balance_dimensions pbd
2710: WHERE balance_name = p_element_name||' Processed Amt'
2711: AND pbd.legislation_code='GB'
2712: AND pbd.dimension_name='_ELEMENT_ITD'
2713: AND pbt.business_group_id = p_business_group_id;
2863: CURSOR c_get_balance_name
2864: IS
2865: SELECT balance_type_id ,pbd.balance_dimension_id
2866: FROM pay_balance_types pbt
2867: ,pay_balance_dimensions pbd
2868: WHERE balance_name = p_element_name||' Processed Amt'
2869: AND pbd.legislation_code='GB'
2870: AND pbd.dimension_name='_ELEMENT_ITD';
2871: