DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_BOOKINGS

Line 466: , per_bookings pb

462: select '

  • '
    463: || ppf.full_name
    464: || '
  • ' interviewer
    465: from per_all_people_f ppf
    466: , per_bookings pb
    467: where ppf.person_id = pb.person_id
    468: and pb.event_id = c_interviewId
    469: and trunc(c_effectiveDate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date);
    470: l_interviewersName varchar2(5000) := null;