pears.NotificationRecipients

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NotificationRecipients" IS 
{CREATE FUNCTION pears."NotificationRecipients"(IN pTransportType CHAR(20), IN pTemplateID CHAR(50), IN pRecipientType CHAR(20), IN pPersonID CHAR(20),IN pVacancyID CHAR(20), IN pCompanyID CHAR(20), IN pDivisionID CHAR(20) ) 
RETURNS CHAR(255)
BEGIN
  -- pTransportType is EMAIL or SMS
  -- pRecipientType is CANDIDATE, CLIENT or AGENCY
  -- Return comma separated list of email addresses or phone number
  -- If no value returned will use normal contact details for the recipient
  -- If returned value starts with + it will be appended to default recipients, otherwise it will replace them
END
}