APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_RUN_RESULTS

Line 133: from pay_run_results prr

129: and pac.assignment_id = p_assignment_id
130: and pac.action_status = 'C'
131: and pac.tax_unit_id = p_tax_unit_id
132: and exists (select 'x'
133: from pay_run_results prr
134: where prr.assignment_action_id = pac.assignment_action_id )
135: order by decode(pay.action_type,'Q','1','R','1','I','2','3');
136: -- note: Also check run_results as might have a payment where there
137: -- was no pay_value. In this case we'll want to see Initialised balance.

Line 186: from pay_run_results prr

182: AND pet.element_name not like 'VERTEX%'
183: AND ee.assignment_id = p_assignment_id
184: AND EXISTS
185: (select prr.element_type_id
186: from pay_run_results prr
187: where prr.source_id = ee.element_entry_id
188: and prr.source_type in ( 'E' , 'I' )
189: and prr.element_type_id + 0 = pet.element_type_id
190: )

Line 432: pay_run_results rr

428: AND pet.element_information10 =pbt.balance_type_id
429: AND EXISTS (SELECT 'x'
430: FROM pay_payroll_actions pact,
431: pay_assignment_actions asg,
432: pay_run_results rr
433: where rr.element_type_id + 0 = pet.element_type_id
434: and rr.assignment_action_id = asg.assignment_action_id
435: and asg.assignment_id = paa.assignment_id
436: and asg.tax_unit_id = paa.tax_unit_id

Line 445: from pay_run_results prr

441: )
442: order by 2;
443: /*
444: AND EXISTS (select prr.element_type_id
445: from pay_run_results prr
446: where prr.assignment_action_id = paa.assignment_action_id
447: and prr.source_type in ( 'E' , 'I' )
448: and prr.element_type_id + 0 = pet.element_type_id
449: )