838:
839: hr_utility.set_location('l_person_type '|| l_person_type || ' :'||l_proc,20);
840:
841: if nvl(l_run_assact_id ,0) > 0 then
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
839: hr_utility.set_location('l_person_type '|| l_person_type || ' :'||l_proc,20);
840:
841: if nvl(l_run_assact_id ,0) > 0 then
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
840:
841: if nvl(l_run_assact_id ,0) > 0 then
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
848:
841: if nvl(l_run_assact_id ,0) > 0 then
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
848:
849: l_cash_component := l_meal_vouc_rfi + l_meal_vouc_nrfi + l_free_acc_rfi + l_free_acc_nrfi;
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
848:
849: l_cash_component := l_meal_vouc_rfi + l_meal_vouc_nrfi + l_free_acc_rfi + l_free_acc_nrfi;
850: hr_utility.set_location('l_cash_component '|| l_cash_component || ' :',20);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);
844: l_meal_vouc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
845: l_meal_vouc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_meal_vouc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
848:
849: l_cash_component := l_meal_vouc_rfi + l_meal_vouc_nrfi + l_free_acc_rfi + l_free_acc_nrfi;
850: hr_utility.set_location('l_cash_component '|| l_cash_component || ' :',20);
851: /* Check if the p_days_worked and l_run_assact_id */