DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_BOOKINGS

Line 615: , per_bookings pb

611: select '

  • '
    612: || ppf.full_name
    613: || '
  • ' interviewer
    614: from per_all_people_f ppf
    615: , per_bookings pb
    616: where ppf.person_id = pb.person_id
    617: and pb.event_id = c_interviewId
    618: and trunc(c_effectiveDate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date);
    619: l_interviewersName varchar2(5000) := null;