APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_REFERRAL_INFO

Line 1424: from irc_referral_info iri,

1420: lookup_code = p_decline_reason;
1421: --
1422: cursor csr_get_apl_referrer_id (p_offer_id in number) is
1423: select iri.source_person_id
1424: from irc_referral_info iri,
1425: irc_offers iof
1426: where iri.object_id = iof.APPLICANT_ASSIGNMENT_ID
1427: and iri.object_type = 'APPLICATION'
1428: and iof.offer_id = p_offer_id;