APPS.PAY_GB_HR_HELPDESK dependencies on DUAL

Line 449: from dual ;

445: if (p_netpay_bal_id is not null) and (p_latest_action_id is not null)
446: then
447: select pay_balance_pkg.get_value(p_netpay_bal_id,p_latest_action_id)
448: into p_pyrl_dtls(p_cnt).TOTAL_NETPAY_YTD
449: from dual ;
450: end if;
451:
452: -- fetch the NI YTD
453: if(p_def_bal_id is not null) and (p_latest_action_id is not null)

Line 457: from dual;

453: if(p_def_bal_id is not null) and (p_latest_action_id is not null)
454: then
455: select pay_balance_pkg.get_value(p_def_bal_id,p_latest_action_id)
456: into p_pyrl_dtls(p_cnt).NI_YTD
457: from dual;
458: end if;
459:
460: p_cnt := p_cnt+1;
461: