APPS.IRC_UTILITIES_PKG dependencies on IRC_NOTIFICATION_PREFERENCES

Line 571: IRC_NOTIFICATION_PREFERENCES INP,

567: CURSOR csr_person_with_notif_prefs(p_person_id NUMBER
568: ,p_effective_date DATE) IS
569: SELECT inp.person_id
570: FROM PER_ALL_PEOPLE_F PPF,
571: IRC_NOTIFICATION_PREFERENCES INP,
572: PER_ALL_PEOPLE_F PPF2
573: WHERE ppf.person_id = p_person_id
574: AND trunc(p_effective_date) BETWEEN ppf.effective_start_date
575: AND ppf.effective_end_date