164: AND (piv.legislation_code='GB' OR piv.legislation_code IS NULL);
165:
166: CURSOR c2_delbal (p_balance_name varchar2) IS
167: SELECT pbt.BALANCE_TYPE_ID
168: FROM pay_balance_types pbt
169: WHERE pbt.BALANCE_NAME = p_balance_name
170: AND pbt.lEGISLATION_CODE = 'GB'
171: AND (pbt.legislation_code='GB' OR pbt.legislation_code IS NULL);
172:
273: AND piv.name IN ('Pay Value');
274:
275: CURSOR c2 (p_balance_name varchar2) IS
276: SELECT pbt.BALANCE_TYPE_ID
277: FROM pay_balance_types pbt
278: WHERE pbt.BALANCE_NAME = p_balance_name
279: AND pbt.lEGISLATION_CODE = 'GB';
280:
281: c1_rec c1%rowtype;