2690: IS
2691: CURSOR c_get_balance_name
2692: IS
2693: SELECT balance_type_id ,pbd.balance_dimension_id
2694: FROM pay_balance_types pbt
2695: ,pay_balance_dimensions pbd
2696: WHERE balance_name = p_element_name||' Processed Amt'
2697: AND pbd.legislation_code='GB'
2698: AND pbd.dimension_name='_ELEMENT_ITD';
2708:
2709: CURSOR c_get_gross_pay_bal_name
2710: IS
2711: SELECT balance_type_id
2712: FROM pay_balance_types pbt
2713: WHERE balance_name = 'Gross Pay'
2714: AND pbt.legislation_code='GB' ;
2715:
2716:
2847:
2848: CURSOR c_get_balance_name
2849: IS
2850: SELECT balance_type_id ,pbd.balance_dimension_id
2851: FROM pay_balance_types pbt
2852: ,pay_balance_dimensions pbd
2853: WHERE balance_name = p_element_name||' Processed Amt'
2854: AND pbd.legislation_code='GB'
2855: AND pbd.dimension_name='_ELEMENT_ITD';