[Home] [Help]
924:
925: -- Get the Employment Equitable Income
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,
954:
955: -- Get the Employment Equitable Annual Income
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,
4902:
4903: -- Get the Employment Equitable Income
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,
4935:
4936: -- Get the Employment Equitable Annual Income
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,
4970: -- Two new balances added for employer contributions
4971: -- Get the Employment Equitable ER Income
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,
5001:
5002: -- Get the Employment Equitable ER Annual Income
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,
5054: from per_pay_bases ppb
5055: where ppb.pay_basis_id = l_assignment.pay_basis_id;
5056:
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,
6307:
6308: -- Get the Employment Equitable Income
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,
6340:
6341: -- Get the Employment Equitable Annual Income
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,
6375: -- Two new balances added for employer contributions
6376: -- Get the Employment Equitable ER Income
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,
6406:
6407: -- Get the Employment Equitable ER Annual Income
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,
6470: and p_report_date between pivf.effective_start_date and pivf.effective_end_date
6471: and p_report_date between pivff.effective_start_date and pivff.effective_end_date;
6472:
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,