APPS.IRC_MDS_MIGRATION dependencies on IRC_NOTIFICATION_PREFERENCES
Line 77: from irc_notification_preferences inp,
73: cursor csr_irc_notifications is
74: select inp.PERSON_ID inp_person_id,
75: pad.town_or_city city,
76: pad.address_type addtype 77: from irc_notification_preferences inp, 78: per_addresses pad
79: where
80: inp.person_id = pad.person_id(+)
81: and pad.ADDRESS_TYPE(+) ='REC'
Line 100: ** For each personid record in IRC_NOTIFICATION_PREFERENCES ,
96: --
97: begin
98: --
99: /* 100: ** For each personid record in IRC_NOTIFICATION_PREFERENCES , 101: ** insert a record in IRC_SEARCH_CRITERIA.
102: */
103: --
104: for c_notifs in csr_irc_notifications loop