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