265: AND paa.payroll_action_id =ppa.payroll_action_id
266: AND pet.element_name not like 'VERTEX%'
267: and pet.element_information10= pDB.balance_type_id
268: AND EXISTS (select prb.balance_value
269: from pay_run_balances prb,
270: pay_defined_balances pdb
271: where prb.defined_balance_id = pdb.defined_balance_id
272: and prb.assignment_id = paa.assignment_id
273: and pdb.balance_type_id = pet.element_information10
351: AND paa.payroll_action_id =ppa.payroll_action_id
352: AND pet.element_name not like 'VERTEX%'
353: and pet.element_information10= pDB.balance_type_id
354: AND EXISTS (select prb.balance_value
355: from pay_run_balances prb,
356: pay_defined_balances pdb
357: where prb.defined_balance_id = pdb.defined_balance_id
358: and prb.assignment_id = paa.assignment_id
359: and pdb.balance_type_id in (pet.element_information10