DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_RUN_BALANCES

Line 269: from pay_run_balances prb,

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

Line 355: from pay_run_balances prb,

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