DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 884: pay_run_result_values prrv,

880:
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

Line 914: pay_run_result_values prrv,

910:
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

Line 4781: pay_run_result_values prrv,

4777:
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

Line 4812: pay_run_result_values prrv,

4808:
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

Line 4845: pay_run_result_values prrv,

4841:
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

Line 4874: pay_run_result_values prrv,

4870:
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