954: OPEN csr_third_party_loc (l_third_party_id) ;
955: FETCH csr_third_party_loc INTO rec_loc_detail;
956: CLOSE csr_third_party_loc ;
957:
958: pay_balance_pkg.set_context('TAX_UNIT_ID', l_leg_emp_id);
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
955: FETCH csr_third_party_loc INTO rec_loc_detail;
956: CLOSE csr_third_party_loc ;
957:
958: pay_balance_pkg.set_context('TAX_UNIT_ID', l_leg_emp_id);
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
956: CLOSE csr_third_party_loc ;
957:
958: pay_balance_pkg.set_context('TAX_UNIT_ID', l_leg_emp_id);
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
964: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID', rec_asg_detail.original_entry_id);
957:
958: pay_balance_pkg.set_context('TAX_UNIT_ID', l_leg_emp_id);
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
964: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID', rec_asg_detail.original_entry_id);
965:
958: pay_balance_pkg.set_context('TAX_UNIT_ID', l_leg_emp_id);
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
964: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID', rec_asg_detail.original_entry_id);
965:
966:
959: pay_balance_pkg.set_context('JURISDICTION_CODE', rec_info.jurisdiction_code);
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
964: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID', rec_asg_detail.original_entry_id);
965:
966:
967:
960: pay_balance_pkg.set_context('DATE_EARNED', to_char(rec_asg_detail.date_earned, 'YYYY/MM/DD HH24:MI:SS'));
961: pay_balance_pkg.set_context('LOCAL_UNIT_ID',rec_info.local_unit_id);
962: pay_balance_pkg.set_context('PAYROLL_ID', rec_asg_detail.payroll_id);
963: pay_balance_pkg.set_context('ORGANIZATION_ID', l_third_party_id);
964: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID', rec_asg_detail.original_entry_id);
965:
966:
967:
968:
966:
967:
968:
969: -- to fetch the balance value of DEDUCTION BASIS balance
970: select pay_balance_pkg.get_value(ele_info.def_bal_id , rec_info.main_asg_act_id)
971: into l_dedn_basis
972: from dual;
973:
974: