eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_RUN_RESULTS

Line 885: pay_run_results prr,

881: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
882: into l_ee_income
883: from pay_balance_feeds_f pbff,
884: pay_run_result_values prrv,
885: pay_run_results prr,
886: pay_payroll_actions ppa,
887: pay_assignment_actions paa,
888: per_assignments_f asg --Bug 4872110
889: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 915: pay_run_results prr,

911: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
912: into l_ee_annual_income
913: from pay_balance_feeds_f pbff,
914: pay_run_result_values prrv,
915: pay_run_results prr,
916: pay_payroll_actions ppa,
917: pay_assignment_actions paa,
918: per_assignments_f asg --Bug 4872110
919: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4782: pay_run_results prr,

4778: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4779: into l_ee_income
4780: from pay_balance_feeds_f pbff,
4781: pay_run_result_values prrv,
4782: pay_run_results prr,
4783: pay_payroll_actions ppa,
4784: pay_assignment_actions paa,
4785: per_assignments_f asg --Bug 4872110
4786: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4813: pay_run_results prr,

4809: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4810: into l_ee_annual_income
4811: from pay_balance_feeds_f pbff,
4812: pay_run_result_values prrv,
4813: pay_run_results prr,
4814: pay_payroll_actions ppa,
4815: pay_assignment_actions paa,
4816: per_assignments_f asg --Bug 4872110
4817: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4846: pay_run_results prr,

4842: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4843: into l_er_income
4844: from pay_balance_feeds_f pbff,
4845: pay_run_result_values prrv,
4846: pay_run_results prr,
4847: pay_payroll_actions ppa,
4848: pay_assignment_actions paa,
4849: per_assignments_f asg
4850: where paa.assignment_id = l_assignment.assignment_id

Line 4875: pay_run_results prr,

4871: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4872: into l_er_annual_income
4873: from pay_balance_feeds_f pbff,
4874: pay_run_result_values prrv,
4875: pay_run_results prr,
4876: pay_payroll_actions ppa,
4877: pay_assignment_actions paa,
4878: per_assignments_f asg --Bug 4872110
4879: where paa.assignment_id = l_assignment.assignment_id