Approval of pending leave applications from backend
Hi, Can any one help me in approval of pending leave applications of 2016 with supervisors??
For this question from one member in the community gave me below script to be run for approving the notifications using notification id..
(BEGIN wf_notification.setattrtext (nid => '4754620', aname => 'RESULT', avalue => 'REJECTED' ); wf_notification.respond (nid => '4754620', respond_comment => 'Reject From backend', responder => 'XXTEST'); COMMIT; END)
for getting those notification id we have used this script –
(select * from wf_notifications where recipient_role in ('username',) and MESSAGE_TYPE='HRSSA' and status='OPEN' and to_char(begin_date,'YYYY')='YYYY')
but can any one tell us how can we know that these notifications are pertaining to leave approval. Appreciate your quick reply