[Home] [Help]
103: ,c_effectiveDate in date) is
104: select 'IRC_CAND_AGENCY_ID:'
105: || inp.agency_id
106: || ';'
107: from irc_notification_preferences inp
108: ,per_all_people_f ppf
109: where inp.person_id = c_candidateId
110: and ppf.person_id = c_candidateId
111: and c_effectiveDate between ppf.effective_start_date