926: begin
927:
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,
956: begin
957:
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,
4904: begin
4905:
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,
4937: begin
4938:
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,
4972: begin
4973:
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,
5003: begin
5004:
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,
6309: begin
6310:
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,
6342: begin
6343:
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,
6377: begin
6378:
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,
6408: begin
6409:
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,