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 932: pay_run_results prr,

928: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
929: into l_ee_income
930: from pay_balance_feeds_f pbff,
931: pay_run_result_values prrv,
932: pay_run_results prr,
933: pay_payroll_actions ppa,
934: pay_assignment_actions paa,
935: per_assignments_f asg --Bug 4872110
936: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 962: pay_run_results prr,

958: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
959: into l_ee_annual_income
960: from pay_balance_feeds_f pbff,
961: pay_run_result_values prrv,
962: pay_run_results prr,
963: pay_payroll_actions ppa,
964: pay_assignment_actions paa,
965: per_assignments_f asg --Bug 4872110
966: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4910: pay_run_results prr,

4906: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4907: into l_ee_income
4908: from pay_balance_feeds_f pbff,
4909: pay_run_result_values prrv,
4910: pay_run_results prr,
4911: pay_payroll_actions ppa,
4912: pay_assignment_actions paa,
4913: per_assignments_f asg --Bug 4872110
4914: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4943: pay_run_results prr,

4939: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4940: into l_ee_annual_income
4941: from pay_balance_feeds_f pbff,
4942: pay_run_result_values prrv,
4943: pay_run_results prr,
4944: pay_payroll_actions ppa,
4945: pay_assignment_actions paa,
4946: per_assignments_f asg --Bug 4872110
4947: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 4978: pay_run_results prr,

4974: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
4975: into l_er_income
4976: from pay_balance_feeds_f pbff,
4977: pay_run_result_values prrv,
4978: pay_run_results prr,
4979: pay_payroll_actions ppa,
4980: pay_assignment_actions paa,
4981: per_assignments_f asg
4982: where paa.assignment_id = l_assignment.assignment_id

Line 5009: pay_run_results prr,

5005: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
5006: into l_er_annual_income
5007: from pay_balance_feeds_f pbff,
5008: pay_run_result_values prrv,
5009: pay_run_results prr,
5010: pay_payroll_actions ppa,
5011: pay_assignment_actions paa,
5012: per_assignments_f asg --Bug 4872110
5013: where paa.assignment_id = l_assignment.assignment_id

Line 5061: pay_run_results prr,

5057:
5058: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value)), 0)
5059: into g_assignments_table(l_assignment.assignment_id).annual_income
5060: from pay_run_result_values prrv,
5061: pay_run_results prr,
5062: pay_payroll_actions ppa,
5063: pay_assignment_actions paa,
5064: per_assignments_f asg
5065: where paa.assignment_id = l_assignment.assignment_id

Line 6315: pay_run_results prr,

6311: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
6312: into l_ee_income
6313: from pay_balance_feeds_f pbff,
6314: pay_run_result_values prrv,
6315: pay_run_results prr,
6316: pay_payroll_actions ppa,
6317: pay_assignment_actions paa,
6318: per_assignments_f asg --Bug 4872110
6319: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 6348: pay_run_results prr,

6344: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
6345: into l_ee_annual_income
6346: from pay_balance_feeds_f pbff,
6347: pay_run_result_values prrv,
6348: pay_run_results prr,
6349: pay_payroll_actions ppa,
6350: pay_assignment_actions paa,
6351: per_assignments_f asg --Bug 4872110
6352: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE

Line 6383: pay_run_results prr,

6379: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
6380: into l_er_income
6381: from pay_balance_feeds_f pbff,
6382: pay_run_result_values prrv,
6383: pay_run_results prr,
6384: pay_payroll_actions ppa,
6385: pay_assignment_actions paa,
6386: per_assignments_f asg
6387: where paa.assignment_id = l_assignment.assignment_id

Line 6414: pay_run_results prr,

6410: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
6411: into l_er_annual_income
6412: from pay_balance_feeds_f pbff,
6413: pay_run_result_values prrv,
6414: pay_run_results prr,
6415: pay_payroll_actions ppa,
6416: pay_assignment_actions paa,
6417: per_assignments_f asg --Bug 4872110
6418: where paa.assignment_id = l_assignment.assignment_id

Line 6477: pay_run_results prr,

6473:
6474: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value)), 0)
6475: into g_new_assignments_table(l_assignment.assignment_id).annual_income
6476: from pay_run_result_values prrv,
6477: pay_run_results prr,
6478: pay_payroll_actions ppa,
6479: pay_assignment_actions paa,
6480: per_assignments_f asg
6481: where paa.assignment_id = l_assignment.assignment_id