92: select 'IRC_CAND_AGENCY_ID:'
93: || inp.agency_id
94: || ';'
95: from irc_notification_preferences inp
96: ,per_all_people_f ppf
97: where inp.person_id = c_candidateId
98: and ppf.person_id = c_candidateId
99: and c_effectiveDate between ppf.effective_start_date
100: and ppf.effective_end_date;
310: || ';'
311: from per_events pe
312: ,irc_interview_details iid
313: ,hr_locations_all loc
314: ,per_all_people_f ppf
315: ,hr_lookups hlk
316: ,hr_lookups hlk1
317: ,fnd_timezones_vl ft
318: where pe.event_id = c_interviewId
372: || c_role
373: || '_EMAIL_ID:'
374: || per.email_address
375: || ';'
376: from per_all_people_f per
377: where per.person_id = c_personId
378: and trunc(c_effectiveDate)
379: between trunc(per.effective_start_date) and trunc(per.effective_end_date);
380: l_personDetails varchar2(1000);
461: , c_effectiveDate date) is
462: select '