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 FND_NUMBER

Line 881: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

877:
878: -- Get the Employment Equitable Income
879: begin
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,

Line 911: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

907:
908: -- Get the Employment Equitable Annual Income
909: begin
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,

Line 4778: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

4774:
4775: -- Get the Employment Equitable Income
4776: begin
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,

Line 4809: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

4805:
4806: -- Get the Employment Equitable Annual Income
4807: begin
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,

Line 4842: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

4838: -- Two new balances added for employer contributions
4839: -- Get the Employment Equitable ER Income
4840: begin
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,

Line 4871: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)

4867:
4868: -- Get the Employment Equitable ER Annual Income
4869: begin
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,