2886:
2887: -- fetch the net pay YTD value
2888: if (p_netpay_bal_id is not null) and (p_latest_action_id is not null)
2889: then
2890: select pay_balance_pkg.get_value(p_netpay_bal_id,p_latest_action_id)
2891: into p_person(j).payroll(p_cnt).TOTAL_NETPAY_YTD
2892: from dual ;
2893: end if;
2894:
2894:
2895: -- fetch the NI YTD
2896: if(p_def_bal_id is not null) and (p_latest_action_id is not null)
2897: then
2898: select pay_balance_pkg.get_value(p_def_bal_id,p_latest_action_id)
2899: into p_person(j).payroll(p_cnt).NI_YTD
2900: from dual;
2901: end if;
2902: